Search found 50 matches

by krystlecsy
Thu Apr 17, 2008 7:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABAP stage trigger Process Chain (SAP)
Replies: 0
Views: 986

ABAP stage trigger Process Chain (SAP)

I would just want to know whether is the ABAP stage capable of calling a Process Chain in SAP? If not, which other stage is capable of doing this?
by krystlecsy
Thu Apr 17, 2008 7:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Triggering ABAP program in SAP
Replies: 0
Views: 1051

Triggering ABAP program in SAP

I am trying to trigger a ABAP program that resides on SAP using the ABAP stage. Is this possible? I am aware that the ABAP program can be created and uploaded using the ABAP stage but I am interested to know whether can it also trigger/execute existing ABAP programs. The current ABAP stage settings ...
by krystlecsy
Mon Dec 03, 2007 9:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see environment variables in Administrator
Replies: 11
Views: 4972

Actually I am not focusing on the migration of the DSParam, what I had in mind is to automate the process of updating a value in DSParam monthly in order for the reflect the latest changes during the job execution every month. Has anyone done that before? :?
by krystlecsy
Sun Dec 02, 2007 7:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see environment variables in Administrator
Replies: 11
Views: 4972

Can I also know that if we were to automate the process of updating the DSParam file, will it immediately reflect the value changes in the Administrator?

Do you have any idea of doing so?
by krystlecsy
Thu Nov 29, 2007 10:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to see environment variables in Administrator
Replies: 11
Views: 4972

I am curious to know does the DSParam file gets generated by every Project? Is this a requirement? What if the file does not exist in the Project folder?
by krystlecsy
Sun Nov 25, 2007 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Access User Defined variables in Parallel Routine
Replies: 3
Views: 2312

In the DataStage v8.0, the problem with the retrieving User Defined Variable in the transformer has been resolved.

The syntax is:-
GetEnvironment("<User Defined Variables>")

Hence, routines are not required anymore. :D
by krystlecsy
Thu Nov 22, 2007 2:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Access User Defined variables in Parallel Routine
Replies: 3
Views: 2312

Access User Defined variables in Parallel Routine

I have read through the threads on the problems of accessing the User Defined variables in Transformers. Hence, I am trying to access the User Defined variables with the Parallel Routine (by writing a C program) and retrieve the values and pass it to the Transformer instead. Now I hit another proble...
by krystlecsy
Thu Jul 26, 2007 7:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Additional sequential warnings
Replies: 12
Views: 6415

We sort of had a workaround in detecting if the records has an import problem. Since the files being read is fixed width delimiter, we added an extra dummy column at the end and if the dummy column has a value, it would mean that the records read has characters that causes it to overrun and will be ...
by krystlecsy
Thu Jul 26, 2007 12:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Additional sequential warnings
Replies: 12
Views: 6415

The problem is that DataStage is not generating all of the warnings even if I set the the 'Warnings: No limit".

The situation is there are 100 records in a file and there are 20 records that has problem but DataStage only displays the 1st problemed record and the rest are ignored.
by krystlecsy
Wed Jul 25, 2007 12:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Additional sequential warnings
Replies: 12
Views: 6415

I cannot find such environment variable that could set it to display all the warning msgs in the Director log. :(

Anyone can help?
by krystlecsy
Mon Jul 23, 2007 9:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Additional sequential warnings
Replies: 12
Views: 6415

The problem the warning message I've gotten is just showing one of the many records that is giving the import problem.

Is there any way besides rejecting the records? I just want to display all the warning in the Director log.
by krystlecsy
Mon Jul 23, 2007 3:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Additional sequential warnings
Replies: 12
Views: 6415

Additional sequential warnings

Hi all, I am getting this warning message from the Director. seqBSIS_2007,0: Import consumed only 228bytes of the record's 230 bytes (no further warnings will be generated from this partition) seqBSIS_2007,0: Import warning at record 588736. The problem is I want MORE of these warnings to pinpoint w...
by krystlecsy
Tue Jan 09, 2007 6:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS affecting column length to multiple?
Replies: 2
Views: 1822

oh, you're saying this one? sorry about that. :oops: i will close this thread and refer to this thread instead.

viewtopic.php?t=106504

thanks, ray!
by krystlecsy
Tue Jan 09, 2007 4:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NLS affecting column length to multiple?
Replies: 2
Views: 1822

NLS affecting column length to multiple?

Hi all, Has anyone encountered setting UTF-8 as the project default settings and whenever we use VARCHAR(UNICODE) or CHAR(UNICODE) datatype, the length of the columns created in Oracle is always multiply by 4. Btw, we are using Write Mode=Replace (creating tables thru DataStage). Example, DataStage:...
by krystlecsy
Tue Jan 09, 2007 4:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cause of RT_STATUSxxx
Replies: 3
Views: 1959

Cause of RT_STATUSxxx

Hi all, I browsed through issues regarding about RT_STATUSxxx or RT_CONFIGxxx and I'm curious to know what are the cause of this? The errors are like:- Cannot open executable job file RT_CONFIGxxx If there are 3 projects residing on the same server but re-build index is only done on 1 of the project...