Hi,
I need to convert my jbase files to RDBMS table (conversion programs
not available). I am using SQL2008, R10 LocalHost.The connection is
successful, created stubfiles and all those stuffs.
While I copied as
COPY FROM FBNK.ACCOUNT TO tempACCOUNT ALL
it shows 2625 records are copied but when I
COUNT tempACCOUNT
no records are listed.
Here FBNK.ACCOUNT is a JR file and tempACCOUNT is a XMLMSSQL file.(I
am able to copy the records to another JR file)
The XMLdriver.log file shows info as,(also attached
the complete log file)
.......
.........
R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar
09 14:31:36 - tempACCOUNT - tempACCOUNT -
dbExecuteRead: Start
R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar
09 14:31:36 - tempACCOUNT - tempACCOUNT - accReadRow:
*** WARNING *** The record is not found!
R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar
09 14:31:36 - tempACCOUNT - tempACCOUNT - drvRead:
drvREAD - Record with key USD190050001 not found
..............
...............
R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar
09 14:31:36 - tempACCOUNT - tempACCOUNT - ErrorRecord:
HResult: 0x80040e14
Description: Statement(s) could not be prepared.
SQLErrorInfo: 42000
Source: Microsoft SQL Server Native Client 10.0
File: dbProcess.cpp, Line: 1993
R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar
09 14:31:36 - tempACCOUNT - tempACCOUNT - ErrorRecord:
HResult: 0x80040e14
Description: Incorrect syntax near the keyword 'as'.
SQLErrorInfo: 42000
Source: Microsoft SQL Server Native Client 10.0
File: dbProcess.cpp, Line: 1993
R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar
09 14:31:36 - tempACCOUNT - tempACCOUNT -
dbExecuteInsert: End
Can anyone help me on this?
Thanks in Advance
--
Please read the posting guidelines at:
http://groups.google.com/group/jBASE/web/Posting%20Guidelines
IMPORTANT: Type T24: at the start of the subject line for questions specific to
Globus/T24
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
