Sybperl Bulkcopy Program Problem 
Author Message
 Sybperl Bulkcopy Program Problem

New to the world of Sybase & Sybperl, I am attempting to
automate the population of Sybase tables with the bcp_
bulkcopy routines in the following way:
1) set up sybperl bulkcopy (bcp_init, bcp_meminit)
2) read ascii data into Perl variables
3) OTHER STUFF (do lookups & updates on existing Sybase tables
   depending on the values of key fields in the ascii data)
4) set up output record & bulkcopy manipulated ascii data to
   one main Sybase table.
I appear to be running into problems doing 3) having done 1) above.
For example, I appear to be able to do 1), 2) & 4) together, and
2) & 3) together, but not 1), 2), 3) & 4) together as I desire.  Am
I missing something?  I am changing strategy to using sql calls to
do "inserts" rather than bulkcopy, or write 2 programs -- the first
to do the fancy stuff & the second to bulkcopy.
Any advice (particularly if accompanied by pointers to complete
programming examples of bulkcopy including methods to sidestep
pesky "logging") would be most welcome.
Thanks
Rob Pates



Mon, 23 Nov 1998 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Can't solve SEGV in Sybperl CTlib program

2. Can't run sybperl program as setuid

3. DMO BulkCopy problems with session settings

4. BulkCopy SQL DMO Problem

5. SQL Server 6.5 DMO - bulkcopy problem

6. SQL DMO Problem: BulkCopy

7. Problem with bulkcopy

8. Problem in bulkcopy

9. ImportData, BulkCopy problem (doesn't do anything)


 
Powered by phpBB® Forum Software