CPYTOIMPF problem

hunshabbir7

2900 pts.

Tags:

CPYTOIMPF

I am using command CPYTOIMPF to convert data from physical file to csv. In TOSTMF parameter of this command I want to pass dynamic folder name with dynamic file name like (/QDLS/&Folder/&File), but it takes hard coded string path like('/QDLS/MyFolder/MyFile.csv'). How to handle it.

Thanks in advance

Asked: June 13, 2014 1:21 PM Last updated: June 19, 2014 4:46 PM

Answer Wiki

Discuss This Question: 5 Replies

pdraebel Jun 13, 2014 2:35 PM GMT

I think you will have to "construct" one variable for the PATH parameter (&PATH). Use a CHGVAR &PATH VALUE('/QDLS/' *tcat &FLR *TCAT '/' &FILE) to put the value in the &PATH variable.

7,545 pointsBadges:

report
hunshabbir7 Jun 16, 2014 5:01 AM GMT

Thanks for reply...
I have tested as you have suggested but it is giving me issue.
"Operands must be
numeric for parameter VALUE."

I have declared parameter as:
DCL VAR(&PATH) TYPE(*CHAR) LEN(50)
CHGVAR &PATH VALUE('/QDLS/'*TCAT &USR *TCAT '/' &FILENAME).
What could be the reason?

2,900 pointsBadges:

report
pdraebel Jun 16, 2014 7:52 AM GMT

Should it not be CHGVAR &PATH VALUE('/QDLS/'*TCAT &USR *TCAT '/' *TCAT &FILENAME).

7,545 pointsBadges:

report
hunshabbir7 Jun 18, 2014 5:07 AM GMT

yes that was my mistake my assignment has been submitted. I made another variable with 1 character length and given it value '/' and concatenate it. Thanks for reply.

2,900 pointsBadges:

report
Splat Jun 19, 2014 4:46 PM GMT

Why create a variable with the value of '/'?

12,450 pointsBadges:

report