Spool file

[John192]

Hi,


how to copy spool file in a database pysical file,there exists a command cpysplf but in to data base file how can we enter a file name dynamically lie when we create cpyf command there we have option create file *yes so similarly at run time how can we copy spool file data in physical file o that we can easily execute sql queries on that physical file which has spool file's data in it.


Thanks

[john.sev99]

Depending on what OS version you are on, you may be able to read the spool file directly from SQL. UDTF SPOOLED_FILE_DATA may be available in SYSTOOLS.
If not (and we're on v7.2 so don't have this), is there a reason you can't automate a CRTPF lib/file RCDLEN(n) followed by a CPYSPLF?