Announcement

Collapse
No announcement yet.

Spool file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Spool file

    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

  • #2
    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?

    Comment

    Working...
    X