DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 625 matches
Author Message
 Topic: List Parameter Questions
FranklinE

Replies: 4
Views: 108

PostForum: General   Posted: Wed Dec 06, 2017 3:39 pm   Subject: List Parameter Questions
The notion of a user "controlling" a production job scares me more than a little bit. I hope you have controls over that which would prevent a user from creating a mess.

In our environment, I'd use ...
 Topic: Loading Binary Data into DB2 using DataStage
FranklinE

Replies: 14
Views: 404

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 01, 2017 9:33 am   Subject: Loading Binary Data into DB2 using DataStage
Ramesh's sample data prompts me to ask: where are you converting to or from EBCDIC and ASCII?

Review all your read/write attributes. I'm guessing this is a character set issue, not the format of th ...
Resolved
 Topic: EBCDIC - multi copybooks, recordId and link col err
FranklinE

Replies: 9
Views: 367

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 28, 2017 12:21 pm   Subject: EBCDIC - multi copybooks, recordId and link col err
Patrick,

The import interface with DataStage works well for Cobol, but it has a couple of flaws. The first one is that it is designed to basic, strict standards being expected, and Cobol has flavor ...
Resolved
 Topic: EBCDIC - multi copybooks, recordId and link col err
FranklinE

Replies: 9
Views: 367

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 27, 2017 12:15 pm   Subject: EBCDIC - multi copybooks, recordId and link col err
You don't have a multiple record type file. You have one record of 180 bytes.

Sorry, but you're barking up the wrong tree.
Resolved
 Topic: EBCDIC - multi copybooks, recordId and link col err
FranklinE

Replies: 9
Views: 367

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 27, 2017 10:04 am   Subject: EBCDIC - multi copybooks, recordId and link col err
Follow the link in my post signature to the FAQ for using mainframe data.

From your description, you have one record definition in two parts, not a header record followed by data records. The clue ...
 Topic: Preview Webinar for new DS release
FranklinE

Replies: 8
Views: 332

PostForum: General   Posted: Tue Nov 21, 2017 1:47 pm   Subject: Preview Webinar for new DS release
First impressions:

Excellent presentations and support from Dennis and his team.

Next time, schedule it for 90 minutes or two hours. I know attendees have time concerns, but this was important t ...
 Topic: insert/update with no key
FranklinE

Replies: 4
Views: 209

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 21, 2017 1:44 pm   Subject: insert/update with no key
For secure and reliable restartability, full (bulk) load is the first choice. Doesn't matter what DBMS you are using, or the structure of the table.

For example:

Job 1 -- bulk unload for backup/ ...
 Topic: Preview Webinar for new DS release
FranklinE

Replies: 8
Views: 332

PostForum: General   Posted: Fri Nov 17, 2017 1:44 pm   Subject: Preview Webinar for new DS release
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Let's discuss it here
I want to encourage everyone who attends the webinar to discuss the new release here. Mostly, it's so I have a chance to see myself write (hear myself speak).
Laughing
Resolved
 Topic: Dynamically export files based on Config table
FranklinE

Replies: 14
Views: 355

PostForum: General   Posted: Thu Nov 16, 2017 12:19 pm   Subject: Dynamically export files based on Config table
I have a loop that uses a list file with parameters, an index (increasing integer, controls the number of loops) and a file name. Each instance of the loop calls a parallel job to FTP get the named fi ...
 Topic: Remove multiple special characters from leading and trailing
FranklinE

Replies: 16
Views: 765

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 15, 2017 8:56 am   Subject: Remove multiple special characters from leading and trailing
You have a logical paradox in your requirements: certain characters are to be removed, except when they are not to be removed. The difference is positional, which is why it's a paradox.

Why must yo ...
 Topic: execute ds job through command line with env file
FranklinE

Replies: 5
Views: 220

PostForum: General   Posted: Wed Nov 01, 2017 1:17 pm   Subject: execute ds job through command line with env file
You should be using a Unix script. If you are trying to manually create the command line, it will not work as you desire.

Sorry, but I won't do your scripting work for you, so no syntax provided.
...
 Topic: FTP to a Mainframe system
FranklinE

Replies: 1
Views: 191

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 18, 2017 10:26 am   Subject: FTP to a Mainframe system
Most likely cause is extra control characters (CR or LF) at the end of the 80-byte record. View the mainframe file in hexadecimal mode, and if they are there you'll see them.

Another possible but l ...
Resolved
 Topic: Remove the First and Last Record of File in FTP
FranklinE

Replies: 6
Views: 396

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 10:36 am   Subject: Remove the First and Last Record of File in FTP
Do the records have a unique identifier, which tells you what kind of record? If so, the transformer constraint can passively drop the header and trailer.

In the mainframe/COBOL world, record type ...
Resolved
 Topic: Remove the First and Last Record of File in FTP
FranklinE

Replies: 6
Views: 396

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 17, 2017 8:27 am   Subject: Remove the First and Last Record of File in FTP
What's the next function after the FTP? If you're landing the file on the server, it's easier to edit the file with a script or with the file stage you are using.

If you are streaming the data dire ...
Resolved
 Topic: XML Error Handling on incomplete file
FranklinE

Replies: 11
Views: 770

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 09, 2017 8:29 am   Subject: XML Error Handling on incomplete file
Marking this resolved, as it isn't an open issue here at this point. I just need to be prepared for future repeats of the incident.

Thanks to all who responded.
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours