Hi,
Can you please help me with a code example?
Thanks.
Search found 143 matches
- Thu Oct 08, 2009 8:30 pm
- Forum: EASYTRIEVE
- Topic: compiling options
- Replies: 3
- Views: 9652
- Thu Sep 24, 2009 9:23 am
- Forum: EASYTRIEVE
- Topic: compiling options
- Replies: 3
- Views: 9652
compiling options
Hi, How to code compiling options in an EZYTRIEVE program like we do in a COBOL program?
Examples would help me a lot.
Thanks.
Examples would help me a lot.
Thanks.
- Tue Sep 22, 2009 2:23 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: a Sub-Query and a Correlated Sub-Query
- Replies: 3
- Views: 9202
inner query?
Hi, Thanks for the reply.
Does inner query execute first or outer query in sub-query / correlated sub-query?
Please explain.
Thanks.
Does inner query execute first or outer query in sub-query / correlated sub-query?
Please explain.
Thanks.
- Sat Sep 12, 2009 9:38 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: a Sub-Query and a Correlated Sub-Query
- Replies: 3
- Views: 9202
a Sub-Query and a Correlated Sub-Query
Hi,
Would you please tell me how a sub-query looks like and a correlated sub-query? Do they always have fixed form of writing it?
Thanks.
Would you please tell me how a sub-query looks like and a correlated sub-query? Do they always have fixed form of writing it?
Thanks.
- Thu Feb 05, 2009 6:28 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT
- Replies: 2
- Views: 4706
- Fri Jan 30, 2009 7:46 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: to merge 2 records of the input file using SORT
- Replies: 18
- Views: 29986
- Fri Jan 30, 2009 4:33 pm
- Forum: FILE-AID
- Topic: COPYBACK fails with MAXCC=8 !
- Replies: 0
- Views: 5026
COPYBACK fails with MAXCC=8 !
Hi, I am trying below job but fails with MAXCC=8. //STEP0004 EXEC PGM=FILEAID //SYSPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //DD01 DD * BAMA1 BAMA2 BAMA3 BAMA4 BAMA5 BAMA6 //DD01O DD SYSOUT=* //SYSIN DD * $$DD01 COPYBACK OUT=1 END //* What is wrong with this JCL? Please help. Thanks.
- Thu Jan 29, 2009 9:36 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: ALTSEQ statement
- Replies: 8
- Views: 13523
- Thu Jan 29, 2009 9:33 pm
- Forum: FILE-AID
- Topic: continuation character in File-Aid batch.
- Replies: 2
- Views: 9672
- Thu Jan 29, 2009 9:27 pm
- Forum: FILE-AID
- Topic: NOT Condition.
- Replies: 7
- Views: 17814
- Thu Jan 29, 2009 7:28 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Copy matching records from 2nd file.
- Replies: 5
- Views: 10161
- Wed Jan 28, 2009 9:40 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Copy matching records from 2nd file.
- Replies: 5
- Views: 10161
- Wed Jan 28, 2009 1:52 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Copy matching records from 2nd file.
- Replies: 5
- Views: 10161
Reply - Here are the details
Frank, Thanks for the reply. Here are the details........ 1). File-A is the 1st file and File-B is the 2nd file. 2). All the output files will have RECFM=FB and LRECL=160. 3). The outputs appear as given below: Output-1: 000 BSS0000000000000001234512009 FLA000A 000 BST0000000001000001234562009 FLS00...
- Tue Jan 27, 2009 9:24 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Copy matching records from 2nd file.
- Replies: 5
- Views: 10161
Copy matching records from 2nd file.
Hi, I have one file that appears as given below. It's RECFM=FB & LRECL=80. The key field here starts at 24th column and it's of 6 bytes. ----+----1----+----2----+----3----+----4----+----5 000001371044800001000001234564800000FLAGP 000001718271300001000001234571300000FLAGP 0000014379716000010000012345...
- Tue Sep 23, 2008 5:38 pm
- Forum: FILE-AID
- Topic: NOT Condition.
- Replies: 7
- Views: 17814
NOT Condition.
Hi, How to use the NOT condition to search entire PS using File-Aid? Generally, we give it like........ //SYSIN DD * $$DD01 COPY IF=(1,0,C'FILEAID') /* I tried the below and it did not work..... :( //SYSIN DD * $$DD01 COPY IF=(1,80,NE,C'FILEAID') /* Any thoughts? Please help. Thanks.