Got it; and I should have caught that link on your sig line, will use it for sure!
TIA,
ff
Search found 30 matches
- Mon Sep 18, 2017 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL CFD table import fails on character string format
- Replies: 4
- Views: 3832
- Mon Sep 18, 2017 7:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL CFD table import fails on character string format
- Replies: 4
- Views: 3832
- Fri Sep 15, 2017 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL CFD table import fails on character string format
- Replies: 4
- Views: 3832
COBOL CFD table import fails on character string format
Greetings, Having a problem importing a COBOL CopyBook as a COBOL FD table def into DSEE via the designer. I get the following error: 'PIC' PICTURE character string format must have at least a 9, A, G, N, or X symbol. In trying to import the following 2 lines in the copybook: 000364 15 ML-CON-LOT-RL...
- Fri Sep 15, 2017 1:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF Stage and special or non-printable characters (again)
- Replies: 3
- Views: 4035
- Wed Sep 06, 2017 1:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF Stage and special or non-printable characters (again)
- Replies: 3
- Views: 4035
- Wed Sep 06, 2017 10:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF Stage and special or non-printable characters (again)
- Replies: 3
- Views: 4035
CFF Stage and special or non-printable characters (again)
Greetings, I've been saddled with a group of DataStage EE and Server jobs that are suffering of the same aliment; seeing special or non-printable characters in various fields in the source records, and can't find a way to eradicate them once in DataStage. I've read the various posts in this forum on...
- Thu Aug 24, 2017 2:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EE Job param TYPE Encrypted makes the value Base64 encoded?
- Replies: 1
- Views: 2249
Problem solved. Turns out the name/value pair I had entered for the custom authentication header, was incorrect based on my interpretation of it. Once I fixed that, we were good. As for the Base64 encoding requirement on the creds, not sure how that was satisfied under the covers as I was using a UT...
- Thu Aug 24, 2017 12:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EE Job param TYPE Encrypted makes the value Base64 encoded?
- Replies: 1
- Views: 2249
EE Job param TYPE Encrypted makes the value Base64 encoded?
Greetings, Trying to call a RESTful web service doing s GET http method in a hierarchical stage; nothing fancy, no request input expected, and response is a text string that returns a status code. Have specified the required authentication header provided, however the username:password pair authenti...
- Thu Aug 24, 2017 12:30 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert MF Date CYYMMDD to DD-MMM-YY:00:00:00
- Replies: 11
- Views: 6951
- Fri Aug 18, 2017 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle OCI Decimal(38) versus Connector DOUBLE
- Replies: 3
- Views: 3783
- Thu Aug 17, 2017 2:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle OCI Decimal(38) versus Connector DOUBLE
- Replies: 3
- Views: 3783
Oracle OCI Decimal(38) versus Connector DOUBLE
IHAC who would like to know why Oracle database NUMBER type that used to import into DataStage via the Oracle OCI Stage as Decimal 38, now come in as DOUBLE via the Oracle Connector.. Any takers?
TIA,
ff
TIA,
ff
- Thu Aug 17, 2017 6:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert MF Date CYYMMDD to DD-MMM-YY:00:00:00
- Replies: 11
- Views: 6951
- Wed Aug 16, 2017 2:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert MF Date CYYMMDD to DD-MMM-YY:00:00:00
- Replies: 11
- Views: 6951
Convert MF Date CYYMMDD to DD-MMM-YY:00:00:00
Greetings, I have an incoming mainframe date which thus far I have converted from a decimal to a string, which comes in the format CYYMMDD ('C' for century, 1 or 0) and I need to convert it to DD-MMM-YY:00:00:00. Any ideas how I can do this in a derivation? I figured I'd start by trimming off the le...
- Wed Aug 16, 2017 10:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector - no design time SQL datatype provided
- Replies: 1
- Views: 2772
Re: Oracle connector - no design time SQL datatype provided
Got to the bottom of this; for whatever reason although the columns and datatypes all lined up with the table in the database, once I imported a fresh table def from the database itself into DataStage and pulled that into my Oracle connector, problem went away! Gotta love those DSEE red herring mess...
- Tue Aug 15, 2017 3:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connector - no design time SQL datatype provided
- Replies: 1
- Views: 2772
Oracle connector - no design time SQL datatype provided
Greetings, Have not seen this one before; imported a table def into an Oracle connector and pushing the output to a peek stage for starters and to eliminate any other logic issues. The job compiles fine but when I go to run it the job aborts and in the log file I find an informational message saying...