iSeries Cobol Technical Discussion Mailing ListMailing list archive for cobol400-l at midrange.comR: Externally Defined Files- June 25, 2008 Not shure if this helps, but try COPY DDR-ALL-FORMAT .... PREFIX BY. More help if you send a copy of your program, i suppose. Nice holidays. D Domenico Finucci P Print this mail only if necessary -----Messaggio originale----- Da: cobol400-l-bouncesxxxxxxx...http://feeds.midrange.com/~r/cobol400-l/~3/319487310/msg00043.html Re: Externally Defined Files- June 24, 2008 Are you using the FD filename. 01 filename-REC. COPY DDS-ALL-FORMATS OF filename ALIAS. Statement What exactly are you wanting to do If you want to use both the field names and the aliases in your program, you can create a working storage area with 01 ws...http://feeds.midrange.com/~r/cobol400-l/~3/319021848/msg00042.html Re: Externally Defined Files- June 24, 2008http://feeds.midrange.com/~r/cobol400-l/~3/319021849/msg00041.html Externally Defined Files- June 24, 2008 Greetings from South Carolina. I am adding a file to a program and thought it would be great if I could define my file with the external fields defined with ALIAS data names. I was trying to avoid creating needless duplicate input specs and thought I could...http://feeds.midrange.com/~r/cobol400-l/~3/318986794/msg00040.html Re: cobol400- June 23, 2008 Kiran, Perhaps we aren't understanding your question. As Robert replied, you can simply "Change your COBOL program type to SQLCBLLE" and it would compile. I would definitely try that first. Trying this will tell you if you've got the SQL-enabled compilers....http://feeds.midrange.com/~r/cobol400-l/~3/318282765/msg00039.html Re: cobol400- June 23, 2008 What have you tried so far that hasn't worked We can take it from there. Scott "kiran eepi" <kiran.eepigmail .com> To Sent by: cobol400-lxxxxxxxxxxxx cobol400-l-bounce cc sxxxxxxxxxxxx Subject COBOL400-L cobol400 06212008 05:25 AM Please respond ...http://feeds.midrange.com/~r/cobol400-l/~3/318173541/msg00038.html cobol400- June 22, 2008 Hi, I just given below coding is in SQL and i need to change this coding into cobol400, Can anyone post what's the solution EXEC SQL SELECT COUNT() INTO : WS-COUNT FROM DB FILE WHERE FIELD 1 = : WS-VAR 1 AND FIELD 2 = : WS-VAR 2 END-EXEChttp://feeds.midrange.com/~r/cobol400-l/~3/317393613/msg00037.html Re: COBOL400- June 21, 2008 Kiran, Change your COBOL program type to SQLCBLLE and embed the SQL into your COBOL code. Robert Munday Munday Software Consultants Montgomery, AL on assignment in Columbia, SC soon to be somewhere else... -----Original Message----- From: cobol400-l-bounce...http://feeds.midrange.com/~r/cobol400-l/~3/316859700/msg00036.html cobol400- June 21, 2008 Hi, I just given below coding is in SQL and i need to change this coding into cobol400, Can anyone post what's the solution EXEC SQL SELECT COUNT() INTO : WS-COUNT FROM GCWQUEP WHERE WQUEACTTCD = : WS-VAR AND WQUEUSERID = : WS-USERID END-EXEC EVALUATE...http://feeds.midrange.com/~r/cobol400-l/~3/316859701/msg00035.html Re: COBOL400-L Digest, Vol 6, Issue 43- June 12, 2008 Satyam, What kind of performance are you seeing with the added call to C to generate the XML I am wondering if you are seeing the job run much longer versus the same job without the XML generation. Our statistics: With no XML: 0:58 elapsed 0:19 CPU With X...http://feeds.midrange.com/~r/cobol400-l/~3/310630431/msg00034.html |