DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 634 matches
Author Message
 Topic: Column to column comparison of DB2 and Hive tables
FranklinE

Replies: 3
Views: 100

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 19, 2018 1:12 pm   Subject: Column to column comparison of DB2 and Hive tables
An old Cobol programmer suggestion learned from an even older Cobol programmer...

If the two versions of data are identically formatted -- meaning there's no difference between DB2 and Hive -- you ...
 Topic: complex mainframe cfd import error
FranklinE

Replies: 1
Views: 154

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jan 05, 2018 12:21 pm   Subject: complex mainframe cfd import error
You'll find a link to the FAQ on using mainframe data at the end of my post.

In general, what you have here is a failure to communicate fully on the Cobol programmers who concocted this mess. You h ...
Resolved
 Topic: Project Name in environment variable?
FranklinE

Replies: 16
Views: 487

PostForum: General   Posted: Wed Dec 27, 2017 2:14 pm   Subject: Project Name in environment variable?
You're welcome, Craig. We have thousands of jobs on multiple platforms -- z/OS, Unix and Windows -- which run nightly and are dependent on variations due to holidays and time constraints. Our ROI for ...
Resolved
 Topic: Project Name in environment variable?
FranklinE

Replies: 16
Views: 487

PostForum: General   Posted: Wed Dec 27, 2017 1:39 pm   Subject: Project Name in environment variable?
BMC Control-M "about" and usage manuals documentation:
https://docs.bmc.com/docs/display/public/workloadautomation/Control-M+Workload+Automation+Documentation

I checked the links, you don't have t ...
Resolved
 Topic: Project Name in environment variable?
FranklinE

Replies: 16
Views: 487

PostForum: General   Posted: Wed Dec 27, 2017 1:31 pm   Subject: Project Name in environment variable?
Told to me by my Cobol instructor: never apologize for ignorance. It gives those of us with a little bit of knowledge a chance to look like geniuses. Laughing

DataStage has a scheduling utility. Loo ...
Resolved
 Topic: Project Name in environment variable?
FranklinE

Replies: 16
Views: 487

PostForum: General   Posted: Wed Dec 27, 2017 12:58 pm   Subject: Project Name in environment variable?
"Server side includes." The general use is to source in script lines that are common to scripts in use. In my experience, they are common function definitions -- get server name, verify existence of d ...
Resolved
 Topic: Project Name in environment variable?
FranklinE

Replies: 16
Views: 487

PostForum: General   Posted: Wed Dec 27, 2017 10:06 am   Subject: Project Name in environment variable?
So how about a loop in your master sequencer?

How would he exit the loop? It's an assumption, but he indicates that the job is time based.
Resolved
 Topic: Project Name in environment variable?
FranklinE

Replies: 16
Views: 487

PostForum: General   Posted: Wed Dec 27, 2017 8:16 am   Subject: Project Name in environment variable?
Sounds like a design problem (ahem, call me Dr. Obvious) but not at the DataStage level. You need a scheduler with cyclic capabilities to control your job runs.

If you don't have an external schedu ...
 Topic: Server Manager - Package Deployment
FranklinE

Replies: 5
Views: 394

PostForum: General   Posted: Fri Dec 15, 2017 9:17 am   Subject: Server Manager - Package Deployment
Pete, maybe I'm confused, but I ask respectfully if with exasperation why the heck you'd want to put objects from more than one project in the same package?

The assumption here is that you are usin ...
 Topic: List Parameter Questions
FranklinE

Replies: 4
Views: 285

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: 741

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: 693

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: 693

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: 693

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: 586

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 ...
 

 Jump to:   



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