Search found 41 matches

by lfong
Wed Oct 10, 2007 7:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running job in control M
Replies: 16
Views: 20904

I assume you are running on the mainframe. If you have universal command, you can control starting, resetting, checking codes of your datastage job through your JCL. In most cases, you will not need sequence jobs. You then use your job scheduler to run your JCL.
by lfong
Tue Jun 12, 2007 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read redefines using parallel complex flat file stage
Replies: 10
Views: 4504

Could you not use the CFF stage into a transform stage. The transform stage would have have multiple outputs. Use constraints for each record type for each corresponding redefined definition.
by lfong
Wed May 16, 2007 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CFF Record
Replies: 6
Views: 1998

In the Administrator, set the option APT_AUTO_TRANSPORT_BLOCK_SIZE
to false.
by lfong
Wed May 16, 2007 5:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error in all the jobs
Replies: 5
Views: 2794

In the Administrator, set the option APT_AUTO_TRANSPORT_BLOCK_SIZE
to false.
by lfong
Wed May 16, 2007 5:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer main_program: Fatal Error: Not a v1.1 type: date
Replies: 4
Views: 2287

In the Administrator, set the option APT_AUTO_TRANSPORT_BLOCK_SIZE
to false.
by lfong
Wed May 16, 2007 5:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error: Not a v1.1 type: decimal
Replies: 4
Views: 1719

In the Administrator, set the option APT_AUTO_TRANSPORT_BLOCK_SIZE
to false.
by lfong
Wed May 16, 2007 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unsupport v1.1 Type Error
Replies: 3
Views: 1490

In the Administrator, set the option APT_AUTO_TRANSPORT_BLOCK_SIZE
to false.
by lfong
Wed May 16, 2007 5:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need help for "Fatal Error: Not a v1.1 type: decimal[20
Replies: 9
Views: 3090

set the APT_AUTO_TRANSPORT_BLOCK_SIZE to false in the administrator .
by lfong
Mon Apr 23, 2007 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Event error during job run.
Replies: 1
Views: 796

Event error during job run.

I have set record performance data in a parallel job, and I am getting the following error: Invalid value for option -f: Data/Performance/Performance/XXX. I created a directory to record performance information, set the value for APT_PERFORMANCE_DATA parm and enabled the job monitoring in the direct...
by lfong
Tue Apr 17, 2007 11:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: getColDesc failed
Replies: 7
Views: 3914

keshav0307 wrote:ooops. i was confused with the similar problem in my a job having Teradata stage.

problem in this job is because the oracle table has a column timestamp type. so the job is running fine in 7.5.2 and giving thsi problem in 7.5.1A.
what paramater setting in the administrator was changed to fix this
by lfong
Tue Apr 17, 2007 11:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: importing definition from Oracle database link
Replies: 1
Views: 939

importing definition from Oracle database link

Is it possible to import table definitions from an oracle database link?
by lfong
Mon Apr 16, 2007 10:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL*Loader-500: Unable to open file
Replies: 10
Views: 13684

Ray, what is the APT_ variable name that has to be set to fix this problem?
by lfong
Mon Apr 16, 2007 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage Column Name Change
Replies: 9
Views: 20767

Just put the column name in double quotes in the SELECT statement. Otherwise the "-" character could be interpreted as a request to perform subtraction. And/or you can use an alias column name in the SELECT statement; there's no need to create a view. Do I have to do anything special with...
by lfong
Thu Apr 12, 2007 10:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify Stage Column Name Change
Replies: 9
Views: 20767

The error message was pretty self-explanatory as to what the problem is. When I use the modify stage to rename the column, I am getting the same error on the oraread. Is there possibly another solution or should I create a view of the table and rename the column with the problem, or call IBM and cre...
by lfong
Wed Apr 04, 2007 6:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copy Stage Error with Oracle Enterprise
Replies: 7
Views: 3606

stopping and starting the DS engine resolved the problem.