RE: CPYTOIMPF question -- MIDRANGE-L

Title: RE: CPYTOIMPF question

Well I have learned more than I would have liked to about it. It does use SQL - The reason I was getting the error is because I fat fingered the file name. But the error I got was a cryptic SQL error. Once corrected, it worked fine. There is still a problem with the code page (like I can't find it for ASCII for the CSSID parm. So what I did is create a template file in ASCII, then use CPYDOC from the template to the new file, then use CPYTOIMPF replacing the file. Since the file exists, it uses the code page for that file. A little kludgy but it works.

Thanks

john

-----Original Message-----
From: Murphy, Guy [mailto:murphy@uif.uillinois.edu]
Sent: Wednesday, May 12, 1999 4:45 PM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: CPYTOIMPF question

It's interesting that you received an SQL error on the CPYTOIMPF command. I guess that means that SQL is the engine behind the command.

Guy Murphy - FACTS system
University of Illinois
217-333-8670

-----Original Message-----
From: John Bussert [mailto:jbussert@stecnet.com]
Sent: Wednesday, May 12, 1999 3:43 PM
To: MIDRANGE-L@midrange.com
Subject: RE: CPYTOIMPF question

Oh shoot me - the command was using QDLDS not QDLS as the IFS folder root.
It worked fine after that. Thanks for the assist.

john

> -----Original Message-----
> From: John Bussert [mailto:jbussert@stecnet.com]
> Sent: Wednesday, May 12, 1999 9:36 AM
> To: MIDRANGE-L (E-mail)
> Subject: CPYTOIMPF question
>
>
> When using the copy to import file command, the to stream
> file, how is that
> formatted and where does it exist. I am trying to copy a
> file to a folder,
> but it fails on the creation of the to file becuase ??? (of course the
> message does not tell me why).
>
> Has anyone used this or the CPYTOSTMF command that has the
> same to parm??
>
> Thanks
>
> Just as an aside - does anyone like the book manager?? It is
> the worst peice
> of software I have ever seen - give me printed manuals.......
> Where is the
> CL programmers reference manual??? Sorry for the rant ;-)
>
> john
>
> John Bussert
> jbussert@stecnet.com
> Swift Technologies, Inc.
> 847-289-8339
> 847-289-8939 fax
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---