Search found 12 matches

by payilagamch
Thu Mar 13, 2014 8:50 am
Forum: COBOL
Topic: getting sqlcode 100
Replies: 7
Views: 9169

Spaces at the end of CNAME4 would be fine i think.
@Myplanet
Can you please cut and paste your exact code here?
by payilagamch
Tue Mar 11, 2014 8:16 pm
Forum: COBOL
Topic: getting sqlcode 100
Replies: 7
Views: 9169

Move CNAME4 to CNAME1 before the FETCH statement.
by payilagamch
Wed Feb 26, 2014 3:02 pm
Forum: COBOL
Topic: How to download DB2 table data into a file or excel sheet?
Replies: 3
Views: 5750

You can use BMC ADUUMAIN utility to unload the table into a dataset in CSV format. Then you can FTP the dataset to Excel sheet and delimit the comuns in the excel sheets by going to DATA --> Text to columns in Excel
by payilagamch
Wed Feb 26, 2014 2:48 pm
Forum: COBOL
Topic: Replace special characters with spaces in a string
Replies: 12
Views: 29158

If you have a list of possible special characters you can use INSPECT with REPLACING.

INSPECT source-string REPLACING ALL '#' BY ' '
ALL '_' BY ' '
by payilagamch
Fri Feb 21, 2014 7:55 am
Forum: JOB VACANCIES
Topic: Mainframe(exp) job opening in Cognizant
Replies: 1
Views: 3412

Thanks for the information.
by payilagamch
Fri Jan 17, 2014 8:10 am
Forum: IMS DB
Topic: Query on IMS Secondary index
Replies: 3
Views: 11238

Yes you have to create a secondary index database . LCHILD and XDFLD of original DB and secondary index should point to each other. Basically it is done in DBDGEN. Please contact your DBA to get it done. Application programmer has to just use the secondary index database name in the PROCSEQ paramete...
by payilagamch
Thu Jan 16, 2014 7:52 am
Forum: COBOL
Topic: Problem with Checkpoint restart logic
Replies: 4
Views: 7093

Hi,

I think you can use a common working storage save area for all the files you use. When you read the file. you move the data to this area and take a check point using this area in CHKP call. When you restart after abend, you can use the details back from this common save area.
by payilagamch
Thu Jan 16, 2014 7:36 am
Forum: IMS DB
Topic: Use of CHNG and PURGE ?
Replies: 4
Views: 9931

Hi, This is the information i got from internet. It does not give clear idea. i want to know in what conditions and how we use these functions practically. If any one has used these functions, please let me know. CHNG call The Change (CHNG) call sets the destination of a modifiable alternate PCB to ...
by payilagamch
Wed Jan 15, 2014 9:18 am
Forum: IMS DB
Topic: Use of CHNG and PURGE ?
Replies: 4
Views: 9931

Use of CHNG and PURGE ?

Can any tell me the what is the exact use of DLI Functions CHNG and PURGE in IMS DB
by payilagamch
Wed Jan 15, 2014 8:56 am
Forum: IMS DB
Topic: PCB address in BMP
Replies: 4
Views: 13452

Hi, As you are sing CMPAT=YES in PSBGEN, DLI will internally use one PCB for checkpoint restart. You have to have two pcbs in linkage section. First one should be IO-PCB. Seocnd one is the pcb for your DB RETDTRAN. Similary you have to use these two pcbs in DLITCBL or PROCEDURE DIVISION USING IO-PCB...
by payilagamch
Tue Jan 14, 2014 1:28 pm
Forum: COBOL
Topic: How to check if data is alphabetic
Replies: 3
Views: 4959

Say you have a variable like this 01 WS-TEST PIC X(10).

you can use the below if statement


IF WS-TEST IS ALPHABETIC
-----
END-IF