Search found 109 matches
- Wed Apr 11, 2007 2:24 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: PACKAGE VS PLAN ?
- Replies: 7
- Views: 29388
Chandra, Wish this helps. packages being better than plans ??? Assume that we have 500 pgms which are bind at the package level,and eventually these pakcage list will be part of the superset called PLAN. When we change say 5 pgms out of these 500 pgms we can rebind only those 5 pgms to the respectiv...
- Tue Apr 10, 2007 4:36 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: File Comparison -Urgent
- Replies: 3
- Views: 9613
Siva, As Frank said you have not mentioned anything regarding the duplicates within each file. And also as per your layout you said 1-16 -> accn no 18-12 ->Amount What is present in 17 postion, are you expecting that in the outfile or only the ACCTNO/AMOUNTS. I have exluded the postion 17 while writ...
- Mon Apr 09, 2007 11:49 pm
- Forum: JCL
- Topic: Override from JCL
- Replies: 7
- Views: 22009
Ajay, Well thanks for the info , But if we give the statement /override //STEP001 EXEC PROCNAME,COND.STEPNAME=VALUE exactly at the call to PROCB from PROCA it should work i guess. I mean where ever second proc is being called from first proc at that step. Sheela if you tried some means and got the s...
- Thu Apr 05, 2007 8:29 pm
- Forum: JCL
- Topic: Is there an IEB utility or some trick in JCL to examine. . .
- Replies: 4
- Views: 13687
seagreg, What ever you have asked can be acheived using the REXX, i mean validatuing the creat date and then sorting based on your condition. But may take some time for coming up with code...but i am sure it can be done. Well if you are really looking for code and if its fine in REXX let us know ..w...
- Thu Apr 05, 2007 8:25 pm
- Forum: EASYTRIEVE
- Topic: Different forms of Case -when (loop handling) in Eazytrieve
- Replies: 3
- Views: 20098
Avani, You mean the CASE statement in EZT. or all the looping syntaxs. Well here is the syntax for CASE * * CHOCIE -> CHOCIE IS NUMERIC THEN WHEN 1 * CHOCIE -> CHOCIE IS ALPHA NUMERIC THEN WHEN '1' * CASE CHOCIE -> CHOCIE WHEN 1 DISPLAY ' CHOCIE 1 IS SELECTED ' WHEN 2 DISPLAY ' CHOCIE 2 IS SELECTED ...
- Thu Apr 05, 2007 5:22 am
- Forum: JCL
- Topic: Override from JCL
- Replies: 7
- Views: 22009
Try This , sorry i missed some info in my earlier post :) //STEP001 EXEC PROCNAME,COND.STEPNAME=VALUE COND.STEPNAME=VALUE -> This is the syntax for overriding the COND values normally. So COND.STEPNAME = VALUE How we give STEPNAME is what we have to figure out since a proc is being called from anoth...
- Thu Apr 05, 2007 5:00 am
- Forum: EASYTRIEVE
- Topic: query in move COMP value to NUMERIC in easytrieve
- Replies: 2
- Views: 10352
- Thu Apr 05, 2007 12:46 am
- Forum: EASYTRIEVE
- Topic: Problem with numeric field with sign in last digit
- Replies: 4
- Views: 18435
Cees Post, I am not clear on few things on ur requirement, 1) P1 1 6 N Value of field is 02236A ---> How can a variable declared (N ->Numeric) has a alpha numeric value 2) As per ur given data P1 = 02236A and what are you tryinG to achieve by doing this N1 = (P1 * -1) ===> you mean N1 = 02236A * (-1...
- Wed Apr 04, 2007 11:22 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: to overcome -407 error in Db2
- Replies: 5
- Views: 14406
harimca, I understand what you are saying that you will no longer get a value from the online screen so you wanted to comment that field. Few things needs to be decided as which approach we are gonna take to prevent the abend/SQL error. 1.But still the column in DB2 table is going to be there right ...
- Wed Apr 04, 2007 11:02 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: to overcome -407 error in Db2
- Replies: 5
- Views: 14406
harimca SQLCODE -407, Error: AN UPDATE, INSERT, OR SET VALUE IS NULL, BUT THE OBJECT COLUMN CANNOT CONTAIN NULL VALUES. Why are u commenting it is there any specific reason for it....why dont you have the field still and initialise appropriately spaces/zero based on the field. Since the field can no...
- Wed Apr 04, 2007 8:55 am
- Forum: EASYTRIEVE
- Topic: Converting Easytrev to EZTPA00
- Replies: 2
- Views: 12570
Scott, Is the code what ever u have given is the complete JCL, please confirm. 1. Because what i am wondering is regarding the data in the I/P file.. looks to me like FILEA data is the temp data sets ...where is it build..?? 2. And coming to other stepnames, i donot see the below stepnames anywhere ...
- Wed Apr 04, 2007 8:19 am
- Forum: JCL
- Topic: Override from JCL
- Replies: 7
- Views: 22009
- Thu Mar 29, 2007 11:29 pm
- Forum: COBOL
- Topic: SQL Query Prob
- Replies: 4
- Views: 11264
DavidatK, Well it slipped of my mind the co-related sub-query did the trick :), always handy for recursive table processing. But i have few questions regarding your query DavidatK 1-> The query you have mentioned is a CURSOR or SINGLETON select ?? What i am assuming is since you are using the co-rel...
- Wed Mar 28, 2007 8:14 pm
- Forum: COBOL
- Topic: SQL Query Prob
- Replies: 4
- Views: 11264
hbkanderi There is separate FORUM for DB2 where you can post your DB2 QUERIES but you have posted in Enterprise COBOL, going forward please take care. Regarding your question, I am not sure if we can do what ever you have asked for in one PARSE with DB2. Well but there are ways by which we can achie...
- Tue Mar 27, 2007 10:17 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: To update a Comment in Lower case in DB2
- Replies: 1
- Views: 9413
harimca, I am not 100% clear regarding ur requiremt as how ur updating, when u say update a String u mean r u passing some value into the string and then moving that into another host variable and then updating that varaible. Anyways just as info : If we can pass a value into a varaible that can be ...