Hi, "R10 LocalHost" and "FBNK.ACCOUNT" definitely means that it's T24- related issue.
Temenos has conversion utility for that task. Regards, VK On Mar 14, 7:36 am, Jen <[email protected]> wrote: > 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
