Search found 51 matches

by CLOPES
Tue Mar 06, 2007 1:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00904 Invalid identifier
Replies: 6
Views: 9459

[quote="csrazdan"]Add a environment variable APT_STRING_PADCHAR to your job and set the value to 0X00

Hope it helps....[/quote]

i'l see it tomorow at work thanks.
by CLOPES
Tue Mar 06, 2007 1:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00904 Invalid identifier
Replies: 6
Views: 9459

[quote="DSguru2B"]What about your metadata? Do you have this column there? Do you have user defined sql?[/quote]

this column don't exist in the target and i don't use user defined in this case.
by CLOPES
Tue Mar 06, 2007 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00904 Invalid identifier
Replies: 6
Views: 9459

ORA-00904 Invalid identifier

Hi All, I create a simple job with DS => TRT => OCI I read a single column in the dataset (ID Bigint) then i add a column timestamp (UPDT_DATE CurrentTimestamp()) in the transformer. I insert them into a table IVRS_DATA_LOG in load and append with parallel option and NLS WE8ISO8859P1. There's just o...
by CLOPES
Fri Jan 27, 2006 3:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to execute cognos transformer through DataStage ExecDOS
Replies: 3
Views: 3713

Hello Right command is : start "cube name" /wait "repertory_to_trsf\trnsfrmr.exe" -nologo -dDataSourceDirectory=repertory_to_iqd_if_you_need_it -dCubeSaveDirectory=repertory_to_cube -n repertory_to_modelPYn\Incidents_hotlineUK.pyi We have several Dos scripts and it works fine. :w...
by CLOPES
Thu Aug 25, 2005 8:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Output Stage
Replies: 2
Views: 1173

Ok

I've understood the problem. The "Validate Schema" was checked and i didn't give it.

Sorry.
by CLOPES
Thu Aug 25, 2005 3:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML Output Stage
Replies: 2
Views: 1173

XML Output Stage

Hi all, I wrote a XML job in XML Pack 1.0 that works fine, Import it in XML Pack 2 trying to use XML output stage but it doesn't work. In Input i have Oracle tables then a transformer and finally the XML output stage. This i swhat i want in output : <lettrages> <lettrage> <action>L</action> <numfact...