Search found 73 matches
- Tue May 04, 2010 4:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: xml source
- Replies: 2
- Views: 2072
xml source
Hi, I have a requirement as: "There are 40 different xml source files with different metadata/schema. I need to create a single job which will read any of these xml files at runtime and convert it to a flat file. I need to create only one job for all the above requirements." I can do this ...
- Mon Apr 26, 2010 7:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Input buffer overrun at field "FIELD_NAME", at off
- Replies: 1
- Views: 4478
Input buffer overrun at field "FIELD_NAME", at off
While trying to import data from a text file(fixed file format) using Schema File for a particular table, we are getting the error Input buffer overrun at field "FIELD_NAME", at offset: 202. Where "FIELD_NAME" is column in the target table. Please advise.
- Fri Mar 26, 2010 8:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stored procedure problem
- Replies: 6
- Views: 4128
stored procedure problem
[* Post Contents removed, duplicate post, not appropriate for thread - Content Editor *]
- Fri Mar 26, 2010 7:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting only the first character of a string as SP output
- Replies: 5
- Views: 3530
I assume that you have tested your stored procedure in SQL server directly and get correct contents returned, so the first question would be how you have declared your datatypes. Actually, the output of the SP is a select stmt from a table based on some conditions. Hence we need not define any data...
- Fri Mar 26, 2010 6:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting only the first character of a string as SP output
- Replies: 5
- Views: 3530
Getting only the first character of a string as SP output
We are calling a Stored Procedure from an ODBC stage. When we execute the SP in SQL Server, it should give the output as a single column having multiple rows of comma dilimited strings as shown below: COLUMN1 tttttttttttttt,59779597,kjjjjjjjjjj jjjjjjjjj,iiiiiiiiiiiiii,999999999 ddddddddd,88884224,b...
- Thu Mar 25, 2010 11:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stored procedure problem
- Replies: 6
- Views: 4128
stored procedure problem
What happens when you try to fire the sql procedure outside of datastage? Any issues then? Any relevent help when you google 'SQLSTATE=42000 '? when I run the sql procedure in sql sqerver it is working fine. But in datastage it is not working. We have created a stored procedure with 3 parameters in...
- Thu Mar 25, 2010 10:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stored procedure problem
- Replies: 0
- Views: 1206
stored procedure problem
here my source is sqlserver.we have created a stored procedure with 3 paramaters in sqlserver these are all input parameter there is no o/p parameters. we want invoke this storedprocedure in datastage using storedprocedure stage.in the datastage how can i pass these parameters.and where we pass thes...
- Thu Mar 25, 2010 8:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stored procedure problem
- Replies: 6
- Views: 4128
stored procedure problem
iam facing a problem in STP stage iam getting these errors.
Stored_Procedure_26,0: Warning: map_test6.Stored_Procedure_26: SQLSTATE = 42000, fNativeError = 201 ,
Stored_Procedure_26,0: Warning: map_test6.Stored_Procedure_26: SQLSTATE = 42000, fNativeError = 201 ,
- Mon Mar 22, 2010 11:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job control process (pid 2100) has failed ?????
- Replies: 7
- Views: 7003
i am waiting for responce :( There is nothing to compel anyone on DSXchange to respond to any post - it is an all-volunteer site and members post when and if they can. If they don't it may be that they don't have anything to add or, (quite unlikely) that they feel offended by something. If you're i...
- Mon Mar 22, 2010 11:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation Error
- Replies: 3
- Views: 2481
- Mon Mar 22, 2010 4:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compilation Error
- Replies: 3
- Views: 2481
Compilation Error
Hi ,
I am getting compilation errorError: Property 'File' for 'Sequential_File_101' is required but empty.I am using sequential file as buffere in my job.Below is the flow of my job.
stage1---> stage----> sequential file-------> stage3-------->stage4.
Please advice
I am getting compilation errorError: Property 'File' for 'Sequential_File_101' is required but empty.I am using sequential file as buffere in my job.Below is the flow of my job.
stage1---> stage----> sequential file-------> stage3-------->stage4.
Please advice
- Sun Mar 21, 2010 10:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job control process (pid 2100) has failed ?????
- Replies: 7
- Views: 7003
i am waiting for responce :( There is nothing to compel anyone on DSXchange to respond to any post - it is an all-volunteer site and members post when and if they can. If they don't it may be that they don't have anything to add or, (quite unlikely) that they feel offended by something. If you're i...
- Sun Mar 21, 2010 10:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: node and partision problem????
- Replies: 6
- Views: 3131
- Sun Mar 21, 2010 9:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: can i delete files from load directory using datastage??
- Replies: 9
- Views: 6765
What I would look at doing would be writing a custom BASIC routine that leveraged DSExecute() to delete whatever filename is passed in. Then your Server job could source from your control table, filter on your status code and select the filename into your job. Then in a transformer, call the routin...
- Sun Mar 21, 2010 9:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job control process (pid 2100) has failed ?????
- Replies: 7
- Views: 7003
Not just from that message... how exactly are you 'calling one job inside another job'? Are there any other messages logged, parent or child? ... i am passing parameter value ,parameter name ,job name to a routine and i am using this routine inside a transformer of parents job. in parents job i got...