Search found 6 matches

by tulasi
Tue Aug 16, 2011 8:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: multiple record structure flat file
Replies: 16
Views: 9834

Re: multiple record structure flat file

Hi
r u able to resolve this issue.
i am also having a similar issue. please help me in this.
by tulasi
Tue Aug 24, 2010 10:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error calling Stored procedure from DataStage
Replies: 0
Views: 3960

Hi
I am also facing the issue mentioned by the option 1.

I am trying to implement the 2nd option still job is failing.could you please elaborate on the process for option 2.

Thanks in Advance!
by tulasi
Fri Feb 27, 2009 5:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS warnings related to CASE expression
Replies: 5
Views: 3351

i ran this query successfully in teradata SQL assistant. it ran fine.but in datastage it is giving the above problem.

please suggest me
by tulasi
Fri Feb 27, 2009 4:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS warnings related to CASE expression
Replies: 5
Views: 3351

DS warnings related to CASE expression

hi all, i am getting the below fatal error while running the DS job: Caught parsing exception during wrapDescribeOperator(): Expected identifier, got: <CASE expression> Job detaisl:loading from TD connector stage to flat file. TD connector contains complex SQL quey which contains CASE expressions. p...
by tulasi
Wed Jun 11, 2008 8:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Using User_defined SQL Query file in DRs Stage
Replies: 2
Views: 1668

Using User_defined SQL Query file in DRs Stage

hi, i am facing problem when trying to place the user defined sql query to the DRS Stage in our job. As the query is too long and complex, i am unable to place the whole query in a single DRS stage.so, thought of Using User_defined SQL Query file option in DRS stage. Could please help me on using th...
by tulasi
Tue Apr 15, 2008 11:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage non-severe system error
Replies: 3
Views: 2304

DataStage non-severe system error

hi all,
I am facing the following error while running the job.

SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "".) SQLSTATE=58004

colud you please help me on this issue.

Thanks in Advance.
Tulasi