IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL code -104


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jul 05, 2012 2:12 pm
Reply with quote

Quote:
Please stop repeating everyone's posts.


if he does not do that,
then his posts only consist of db2 must be wrong.

To take a file of account numbers (or anything),
edit the file,
shift all account numbers so that they start on a certain column,
MOVE double quotes, commas OVER all the numbers,
zero fill (pad to the left) certain columns
would take about 10 seconds,
whereas the TS has a Tool that does not work.

as i said before, this boring thread is about someone,
who has made a fundamental mistake,
is incapable of taking the time to find the 'error',
and keeps insisting that db2 is at fault.

last real restriction on db2 query size was db2 vn7.

the problem is not the phantom restrictions imposed by db2,
it is the personality of the TS.
Back to top
View user's profile Send private message
preethan
Warnings : 1

New User


Joined: 15 Dec 2008
Posts: 33
Location: Chennai

PostPosted: Thu Jul 05, 2012 2:30 pm
Reply with quote

I dont blame db2. You completely misunderstood me here. I doubted that db2 might have a constraint in the size of the query. I never knew that the size problem is sorted after version 7. Thanks for calling me incapabale, I very well know about my capabilities in fixing the error. I come here only if the issue is hard to sort out. It doesnot mean that i failed to fix the error. I found an alternate way
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jul 05, 2012 2:37 pm
Reply with quote

Quote:
It doesnot mean that i failed to fix the error. I found an alternate way


so much BS.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Thu Jul 05, 2012 2:51 pm
Reply with quote

We're not heading anywhere, I'm locking this topic.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Monitoring production job progress. N... JCL & VSAM 4
Search our Forums:

Back to Top