Search found 109 matches

by Veera
Wed Apr 11, 2007 2:24 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PACKAGE VS PLAN ?
Replies: 7
Views: 22467

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...
by Veera
Tue Apr 10, 2007 4:36 am
Forum: DFSORT , ICETOOL & Utilities
Topic: File Comparison -Urgent
Replies: 3
Views: 7080

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...
by Veera
Mon Apr 09, 2007 11:49 pm
Forum: JCL
Topic: Override from JCL
Replies: 7
Views: 16912

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...
by Veera
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: 10591

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...
by Veera
Thu Apr 05, 2007 8:25 pm
Forum: EASYTRIEVE
Topic: Different forms of Case -when (loop handling) in Eazytrieve
Replies: 3
Views: 16833

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 ...
by Veera
Thu Apr 05, 2007 5:22 am
Forum: JCL
Topic: Override from JCL
Replies: 7
Views: 16912

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...
by Veera
Thu Apr 05, 2007 5:00 am
Forum: EASYTRIEVE
Topic: query in move COMP value to NUMERIC in easytrieve
Replies: 2
Views: 8889

Naru, As dbzTHEdinosauer said you need to see what is your code an assignment or a move. I donot see any problem with the below code. PARM ABEXIT(SNAP) PRESIZE 1024 * DEFINE WS-COMPFLD-A W 3 P VALUE 12345. DEFINE WS-COMPFLD-B W 3 P VALUE 0. * DEFINE WS-NUMFLD-A W 5 N VALUE 12345. DEFINE WS-N...
by Veera
Thu Apr 05, 2007 12:46 am
Forum: EASYTRIEVE
Topic: Problem with numeric field with sign in last digit
Replies: 4
Views: 15843

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...
by Veera
Wed Apr 04, 2007 11:22 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: to overcome -407 error in Db2
Replies: 5
Views: 10627

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 ...
by Veera
Wed Apr 04, 2007 11:02 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: to overcome -407 error in Db2
Replies: 5
Views: 10627

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...
by Veera
Wed Apr 04, 2007 8:55 am
Forum: EASYTRIEVE
Topic: Converting Easytrev to EZTPA00
Replies: 2
Views: 10855

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 ...
by Veera
Wed Apr 04, 2007 8:19 am
Forum: JCL
Topic: Override from JCL
Replies: 7
Views: 16912

Try this PROC1.STEPNAMEA.STEPNAMEB STEPNAMEA -> Is the step name where another proc is called STEPNAMEB -> Is the step name of the second proc for which you want to override the parameter. and then give the step with what ever cond u want to override with. Thanks, Veera.
by Veera
Thu Mar 29, 2007 11:29 pm
Forum: COBOL
Topic: SQL Query Prob
Replies: 4
Views: 8982

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...
by Veera
Wed Mar 28, 2007 8:14 pm
Forum: COBOL
Topic: SQL Query Prob
Replies: 4
Views: 8982

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...
by Veera
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: 7269

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 ...