Search found 17 matches
- Mon Jul 19, 2010 6:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
- Sun Jul 18, 2010 4:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
They're part of the Packed classification of the Decimal data type, which includes zoned and overpunch and which allows you to specify whether the 'sign' is leading or trailing. I am now able to see the output using below option character set =ASCII Data format=Text record delimeter = \n byte order...
- Fri Jul 16, 2010 10:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
Yes, you should be able to use the CFF for this, provided you know the data types. Did you try ASCII yet, do things look better when you do? if we use a CFF stage, then how to specify the decimal properties which phil suggested, no overpunch and leading .I dont see such options in a cff stage.Moreo...
- Fri Jul 16, 2010 9:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
- Fri Jul 16, 2010 8:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
- Fri Jul 16, 2010 8:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
- Fri Jul 16, 2010 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
- Fri Jul 16, 2010 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem viewing the output of cff stage
- Replies: 20
- Views: 8662
problem viewing the output of cff stage
Hi we are using a cff stage for reading a mainframe file which is sent in ASCII format. We are using the below properties in CFF stage byte order:native endian character set=EBCDIC data format=text record delimiter=\n While viewing or writing the output to a file, we see only junk characters like ??...
- Fri Jul 16, 2010 2:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Import error in cff stage for a comp value
- Replies: 1
- Views: 1379
Import error in cff stage for a comp value
Hi While reading a mainframe file i am getting below error >##E TOIX 000227 09:10:51(002) <cffRequest,0> Trouble importing field "FILLER_3"; data: {0 { 0 0 { 0 0 { 0 0 { 0 0 { The filler_3 is defined as 07 FILLER PIC S9(09) COMP VALUE 6380. record options are data format = text character s...
- Wed Sep 09, 2009 2:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [DataDirect][ODBC lib] Function sequence error
- Replies: 3
- Views: 2970
- Tue Sep 08, 2009 11:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error after installing the patch for range partitioned table
- Replies: 1
- Views: 1773
error after installing the patch for range partitioned table
we have recently applied the below patch on datastage parallel edition 7.5 patch_118136 - PROBLEM REPORTED "DB2 operators do not support parallel execution against range partitioned tables" After applying the patch we are getting the below errors 1. db2CUST_IP_INTERFACE_HEWsel,0: Fatal Err...
- Tue Sep 08, 2009 11:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [DataDirect][ODBC lib] Function sequence error
- Replies: 3
- Views: 2970
[DataDirect][ODBC lib] Function sequence error
We are facing a problem in our Production on daily basis. There are few jobs which are failing on day to day basis because of error, main_program: [DataDirect][ODBC lib] Function sequence error. And these jobs are getting over successfully after re run. The jobs are scheduled in control M. It is obs...
- Wed Jun 10, 2009 2:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Jobs running slow on Tuesday
- Replies: 2
- Views: 3487
Jobs running slow on Tuesday
Hi, we have a scenario where in many datastage jobs in production run quite slow as compared to other days. Some jobs also fail only on Tuesday with the error below ============================================= main_program: APT_PMsyncWithSectionLeaders: non-zero status 1 from APT_PMpollUntilZero. =...
- Mon Feb 25, 2008 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: TIMESTAMP(6) WITH LOCAL TIME ZONE datatype
- Replies: 0
- Views: 1414
TIMESTAMP(6) WITH LOCAL TIME ZONE datatype
Hi I am extarcting data from a table in oracle. One of the column is having a datatype as TIMESTAMP(6) WITH LOCAL TIME ZONE. When i query the oracle at sqlplus promt i get the column value as select Open_date from open_tckt where ref_num = 'IN26' 2 / OPEN_DATE ---------------------------------------...
- Fri Nov 16, 2007 9:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bad record processing
- Replies: 2
- Views: 1388