the solution to the problem was to change the delimiters in the sql query..
regards
Search found 23 matches
- Wed Nov 16, 2011 12:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Microsoft Access ERROR
- Replies: 1
- Views: 1925
- Wed Nov 16, 2011 9:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ODBC Microsoft Access ERROR
- Replies: 1
- Views: 1925
ODBC Microsoft Access ERROR
Hi guys, im having the following problem, its the first time i make a odbc to import data from a microsoft access database. i have no problem to import the tables from the database but when y make a job server and i press view from an especific tablei get this error. DSBrowser..ODBC_0.DSLink2: DSD.B...
- Wed May 04, 2011 9:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extrancting data from Text file
- Replies: 1
- Views: 1292
Extrancting data from Text file
Hi Datastage Masters,
im trying to get data from a flat file(txt) to a Oracle_OCI. the problem is taht when i run de job i get this error:
[000001]Untitled464..Sequential_File_0.DSLink9: nls_read_fixedwidth() - row 1, column XXX, column unexpectedly ended by EOR
Someone that enlighten me,
thanks
im trying to get data from a flat file(txt) to a Oracle_OCI. the problem is taht when i run de job i get this error:
[000001]Untitled464..Sequential_File_0.DSLink9: nls_read_fixedwidth() - row 1, column XXX, column unexpectedly ended by EOR
Someone that enlighten me,
thanks
- Wed May 04, 2011 9:00 am
- Forum: General
- Topic: ERROR Unable to open the Job
- Replies: 8
- Views: 9862
- Mon May 02, 2011 9:35 am
- Forum: General
- Topic: ERROR Unable to open the Job
- Replies: 8
- Views: 9862
- Mon May 02, 2011 6:43 am
- Forum: General
- Topic: ERROR Unable to open the Job
- Replies: 8
- Views: 9862
ERROR Unable to open the Job
Hello guys, im having this problem when i want to open any job (server or sequence). Unable to open the Job Unable to get EObject c2e76d84.43058877.4e410a86.76875176-b082-429c.a382.d10d3ed182c8 com.ibm.datastage.exception.DSException: Unable to get EObject c2e76d84.43058877.4e410a86.76875176-b082-42...
- Tue Apr 19, 2011 10:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Call Subroutine Before/After
- Replies: 4
- Views: 2655
- Tue Apr 19, 2011 9:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Call Subroutine Before/After
- Replies: 4
- Views: 2655
Call Subroutine Before/After
Hi Masters of datastage, im having a problem calling a subroutine into a OracleOCI before/after. My routine resets the job: ($INCLUDE DSINCLUDE JOBCONTROL.H AuditHandle = DSAttachJob("InputArg" ,DSJ.ERRNONE) RunErr = DSRunJob(AuditHandle, DSJ.DSJ.RUNRESET ) ) the question is, how i can cal...