Search found 262 matches

by pavan_test
Wed Aug 20, 2008 8:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datastage error
Replies: 8
Views: 1838

datastage error

when ever i log in to the datastage i am getting the follwoing message;
cannot open executable job file RT_CONFIG113

can anyone please suggest me why am I getting this message and the resolution.

Thanks
Mark
by pavan_test
Mon Aug 11, 2008 10:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: generate osh
Replies: 3
Views: 2913

generate osh

Hi All, I am working on data stage 8x and OS aix 5.3 In data stage 7.5.2 version Parallel jobs generate osh script which can be viewed in the job properties window, Generated OSH tab however in version 8x i am not able to find the Generated OSH tab in the job properties window can anyone please let ...
by pavan_test
Tue Aug 05, 2008 8:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1936

Re: ORA-01461

Can anyone please suggest me if you have encountered such errors with oracle enterprise edition as target stage in 8.0.1 version. please suggest me what did you do to resolve it.

The same job was successful in data stage version 7.5.2

Thanks
Mark
by pavan_test
Tue Aug 05, 2008 7:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1936

ORA-01461

i did not find any information regarding varchar in the release notes :(

Thanks
Mark
by pavan_test
Tue Aug 05, 2008 7:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1936

ORA-01461

i did not find any information regarding varchar in the release notes :(

Thanks
Mark
by pavan_test
Tue Aug 05, 2008 4:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1936

ORA-01461

I verified the data types of all the columns in my datastage job (target stage:Oracle Enterprise Edition) and i did not find any column with data types long,nchar or nvarchar. i also verified data types for all the columns in the target database table and none of them are long. the data stage job is...
by pavan_test
Tue Aug 05, 2008 2:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1936

Re: ORA-01461

can anyone please give me advice me.

thanks
mark
by pavan_test
Tue Aug 05, 2008 1:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1936

Re: ORA-01461

my dba says it is datastage problem since he is able to update/insert into the same database.

please give me suggestions

thanks
Mark
by pavan_test
Tue Aug 05, 2008 1:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-01461
Replies: 9
Views: 1936

ORA-01461

Hi All, I am running a data stage job in 8.0.1. all my input and output stages are oracle enterprise endition stages. none my columns in my input and output stages are long or nchar or nvarchar however wen i run my job it is aborting with this error at the output oracle stage; sqlcode is: -1461 esql...
by pavan_test
Mon Jul 28, 2008 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_BufferOperator
Replies: 4
Views: 7809

APT_BufferOperator

Hi All, I have a problem in while running a data stage job in version 8x. os is aix. buffer(11),0: APT_BufferOperator warning: currentWriteTime <= lastWriteTime, 1216910062.65395 1216910103.79412 buffer(0),1: APT_BufferOperator warning: currentWriteTime <= lastWriteTime, 1216910062.66623 1216910103....
by pavan_test
Fri Jul 25, 2008 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Escape character in v8
Replies: 6
Views: 2984

Re: Escape character in v8

Please give me suggestions

Thanks
Mark
by pavan_test
Thu Jul 24, 2008 2:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Escape character in v8
Replies: 6
Views: 2984

Escape character in v8

Im passing an Sql query as a parameter to the job e.g select name where state in ('NY','NJ') The query works fine in Oracle but when I pass it as a parameter to the job, it fails. On going through the log I saw that the query was not getting coverted properly. The log was as follows : Oracle_Enterpr...