Coding Challenge #1 : Generating csv using CPYTOIMPF | yusy4code

  Рет қаралды 6,686

Yusy4Code

Yusy4Code

Күн бұрын

Пікірлер: 18
@infoonline1133
@infoonline1133 4 жыл бұрын
|Great sir!!!
@marathmolatechie
@marathmolatechie 6 ай бұрын
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
@claudiawhite392
@claudiawhite392 6 жыл бұрын
Thank you, Yusuf. This has indeed helped me.
@yusy4code
@yusy4code 6 жыл бұрын
Claudia White Glad to know 😊
@vasalokesh8653
@vasalokesh8653 3 жыл бұрын
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.
@yusy4code
@yusy4code 4 жыл бұрын
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.
@higiniofuentes2551
@higiniofuentes2551 3 жыл бұрын
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-xb8hl
@Andrew-xb8hl 6 жыл бұрын
Just finished watching this yusuf, this is great. Cant wait to get into this. i like the idea on coding challenges, good
@gayanperera3156
@gayanperera3156 5 жыл бұрын
Is there a way to build mulitiple excel sheets in a single excel form from as400? 😕
@dhivyaprabhu2953
@dhivyaprabhu2953 4 жыл бұрын
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-ti8vy
@UmairKhan-ti8vy 6 жыл бұрын
Hi yusuf It is really helpful for us. Could you please make one video on use of SFLNXTCHG & READC on subfile. Thanks
@yusy4code
@yusy4code 6 жыл бұрын
ya already planning to do....
@UmairKhan-ti8vy
@UmairKhan-ti8vy 6 жыл бұрын
And please try to cover the sflfold and sfldrop also... Thank you
@adityabadhe3295
@adityabadhe3295 5 жыл бұрын
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?
@AmarKumar-uj9cv
@AmarKumar-uj9cv 4 жыл бұрын
very useful:)
@manishshukla8970
@manishshukla8970 6 жыл бұрын
Nice yousuf....
How to use Physical File (PF) Trigger in RPGLE - IBM i (AS400)
12:15
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 700 М.
coco在求救? #小丑 #天使 #shorts
00:29
好人小丑
Рет қаралды 120 МЛН
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
[004] IBM i (AS/400): Import CSV file into physical file
27:30
Mainframes & More with Matthew
Рет қаралды 10 М.
Microservices are Technical Debt
31:59
NeetCodeIO
Рет қаралды 686 М.
Introduction to Printer file (PRTF) in IBM i (AS400)
14:38
Yusy4Code
Рет қаралды 32 М.
Physical & Logical file Intro  - Part 1 Beginners
9:40
Yusy4Code
Рет қаралды 39 М.
Master Pointers in C:  10X Your C Coding!
14:12
Dave's Garage
Рет қаралды 334 М.
It’s time to move on from Agile Software Development (It's not working)
11:07
Programming with Math | The Lambda Calculus
21:48
Eyesomorphic
Рет қаралды 246 М.
🚀  TDD, Where Did It All Go Wrong (Ian Cooper)
1:03:55
DevTernity Conference
Рет қаралды 572 М.
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 700 М.