Search found 8 matches

by vinodkumards
Thu Jun 06, 2013 11:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue with Date format in SP
Replies: 12
Views: 6843

SQLSTATE = HY000, fNativeError = 0
date format picture ends before converting entire input string ORA-06512: at
by vinodkumards
Thu Jun 06, 2013 1:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue with Date format in SP
Replies: 12
Views: 6843

Any solution for this issue?
by vinodkumards
Wed Jun 05, 2013 9:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue with Date format in SP
Replies: 12
Views: 6843

If pass date as '2013-06-06' gives the same error.
by vinodkumards
Tue Jun 04, 2013 10:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue with Date format in SP
Replies: 12
Views: 6843

storedProedure( in,out )
by vinodkumards
Tue Jun 04, 2013 7:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue with Date format in SP
Replies: 12
Views: 6843

issue with Date format in SP

Hi,

I get the following error while calling an oracle stored procedure using Stored procedure stage

[IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-01830: date format picture ends before converting entire input string ORA-06512:

issue?

Any input is highy appreciated.
Thanks
by vinodkumards
Wed Feb 22, 2012 2:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: filter stage usage
Replies: 3
Views: 2691

filter stage usage

Hi, I want to know how to use filter stage after change capture stage to capture change code values for insert,update delete and copy.In where clause do I need to put where Clause=0 where clause =1 and so on? Please clarify as it throws an error.

Thanks in advance
by vinodkumards
Tue Sep 06, 2011 11:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Disk space issue
Replies: 9
Views: 4416

Ray, Could you pls help me to find the disk space for the scenario that I mentioned..yes it for logs.. there is around 830 Gb occupied in 4 different parts each 830 Gb.. whic is a lot of space