I am getting junk values in CSV, the as400 files fields where created using CAST SQL statements which are resulting in junk values when i do CPYTOIMPF pls tell me solution
@claudiawhite3926 жыл бұрын
Thank you, Yusuf. This has indeed helped me.
@yusy4code6 жыл бұрын
Claudia White Glad to know 😊
@vasalokesh86533 жыл бұрын
Hi yusuf I am trying to copy data with semicolon as flddlm but showing error on qcmdexc what i can do now?
4 жыл бұрын
Hi yusuf, how can I copy a file ordered when Fromfile is a logical file. This example make the output order as it is in the physical file but i would like the order as it in the logical.
@yusy4code4 жыл бұрын
I hope it should work if we provide LF file name in from file column. Have you tried it?
4 жыл бұрын
@@yusy4code CPYTOIMPF FROMFILE(PRDDTA/ZRE1 *FIRST) TOSTMF('/life/prdflr/reports/test/ zre1el.csv') MBROPT(*REPLACE) STMFCCSID(*PCASCII) RCDDLM(*CRLF) FLDDLM(';') ADDCOLNAM(*SQL) This is my command where ZRE1 is the name of the LF. Unfortunately zre1el.csv is not in the order of LF buf in order of PF.
@higiniofuentes25513 жыл бұрын
Thank you for this very interesting video Yusuf! (As usual) You can do this with a CL program with variables in 2 steps: 1/ create the qtemp/temp file with select into and with the condition you want 2/ use the cpytoimpf from the qtemp/temp to the CSV Is this correct?
@Andrew-xb8hl6 жыл бұрын
Just finished watching this yusuf, this is great. Cant wait to get into this. i like the idea on coding challenges, good
@gayanperera31565 жыл бұрын
Is there a way to build mulitiple excel sheets in a single excel form from as400? 😕
@dhivyaprabhu29534 жыл бұрын
While converting into CSV, the date format is changing sir! MM/DD/YY is changing into MM/DD/YYYY for the dates equal to and below 12. Is there any solution for this?
@UmairKhan-ti8vy6 жыл бұрын
Hi yusuf It is really helpful for us. Could you please make one video on use of SFLNXTCHG & READC on subfile. Thanks
@yusy4code6 жыл бұрын
ya already planning to do....
@UmairKhan-ti8vy6 жыл бұрын
And please try to cover the sflfold and sfldrop also... Thank you
@adityabadhe32955 жыл бұрын
hi, i'm in a migration project which involve As400. I need to prepare a log info of the data schema, that is the File description like Field Name, Data Type, Field Length, Start Position, Alias Field Name. I need to import this info into excel. Could you help me with this?