Search found 733 matches

by FranklinE
Wed Aug 18, 2010 9:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Schema files and RCP via Hamlet: To use or not to use?
Replies: 2
Views: 3622

Schema files and RCP via Hamlet: To use or not to use?

I'm building a new application that on the surface is relatively simple. I have a list of data sources that are mostly mainframe datasets with a shorter list of copybooks involved, meaning that some record formats are for more than one dataset. My goal is to parameterize the application as much as i...
by FranklinE
Mon Aug 16, 2010 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data capture in sql
Replies: 5
Views: 3265

Database deltas

For a low-volume database, we "cheat" a bit. Using the first load as the starting point for my description, the load file for the first day is the "new" file, and there is no "old" file involved. We preserve the "new" file and rename it to "old" for ...
by FranklinE
Thu Aug 05, 2010 1:40 pm
Forum: Site/Forum
Topic: Suggestion: separate forums for tech & design help reque
Replies: 4
Views: 5639

Good ideas. I think forums for PX functions and server routines might help searching or finding good ideas. Maybe a forum for database design and/or table/index design. I would like to see FAQ for performance tuning ideas or suggestions or on the above topics. Maybe FAQs could point people in right...
by FranklinE
Thu Aug 05, 2010 1:25 pm
Forum: Site/Forum
Topic: Suggestion: separate forums for tech & design help reque
Replies: 4
Views: 5639

chulett wrote:Sorry, needed to move you down to the proper forum for things of this nature.
It's all okay. I owe you an apology for not finding the right forum in which to post this. Thanks.
by FranklinE
Thu Aug 05, 2010 11:43 am
Forum: Site/Forum
Topic: Suggestion: separate forums for tech & design help reque
Replies: 4
Views: 5639

Suggestion: separate forums for tech & design help reque

I'll concede up front that this is a question of convenience, but I'm betting that I'm not the only one with a restricted amount of time to spend on tech forums. I suggest that there be two separate forums or sub-forums. One for "this is my current code and problem, can anyone help?" and a...
by FranklinE
Fri Jul 23, 2010 8:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Controlling the data flow between the stages in same job.
Replies: 15
Views: 8474

Re html code: There's only so much data that my sieve-like memory can sift. Old dog new trick, and I appreciate getting help. :oops: My teen-aged daughter knows html better than I do. Hemachandra, I did miss your modified requirement description. Sorry about that. You should be able to handle this i...
by FranklinE
Thu Jul 22, 2010 8:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Controlling the data flow between the stages in same job.
Replies: 15
Views: 8474

Something similar

I've used the after-job routine to accomplish something like this: create separate (differently named) intermediate sequential files, than at the end concatenate them (in the order you require) into the final file with an after-job routine. Another possiblity, one I haven't thought through in any de...
by FranklinE
Tue Jul 20, 2010 8:21 am
Forum: General
Topic: Have I stepped on the forum etiquette toes?
Replies: 5
Views: 1942

Yep, some of us date back to version 1.0 (and further!) - some of the knowledge is still there in the ol' grey cells! Now to your question. Some advances do get backdated into earlier releases - for example version 7.5.3 contains some goodies first released in version 8. So don't be backwards about...
by FranklinE
Mon Jul 19, 2010 9:27 am
Forum: General
Topic: Have I stepped on the forum etiquette toes?
Replies: 5
Views: 1942

Thanks, Andy. I wasn't worried about being ostracized. I've been in cyberspace long enough to assume that silence just means silence (even when biting my fingernails hoping for a response).

I am new to "blithely going where no geek has gone before". Be well. :)
by FranklinE
Mon Jul 19, 2010 9:10 am
Forum: General
Topic: Have I stepped on the forum etiquette toes?
Replies: 5
Views: 1942

Have I stepped on the forum etiquette toes?

I'm stuck. I don't get to make the decision to upgrade to 8x. I even have professional sympathy for the reasons to not upgrade. The problem is that I'm further stuck trying to make 7x work with environment changes (Unix, particularly SSHv2) that IBM has no intention supporting in 7x. Am I wasting my...
by FranklinE
Thu Jul 15, 2010 9:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get rid of COBOL levels in datastage Data Set column defs?
Replies: 15
Views: 15846

My suggestion is based on a practical view. For example, go through the Repository view and open the table properties. On the layout tab, click on the Parallel view. This is how the meta data looks at its basic level. The record_format line preserves the Cobol attributes you must have. The rest make...
by FranklinE
Thu Jul 15, 2010 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get rid of COBOL levels in datastage Data Set column defs?
Replies: 15
Views: 15846

Is there some process that will allow me to not have to manually populate the 99 columns because 3 columns have a level value? I had a recent run-in trying to maintain the packed decimal attribute for incoming data on a Cobol copybook format. In working through the table import process, and being e...
by FranklinE
Wed Jul 14, 2010 9:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OpenSSH: workaround to implement SFTP in Parallel jobs
Replies: 0
Views: 1124

OpenSSH: workaround to implement SFTP in Parallel jobs

I'm faced with the enviable task of implementing SFTP in new development under a strong pressure to not upgrade to 8x. Has anyone looked into implementing SFTP in a parallel job, and/or attempting to use the Connection option in FTP Enterprise to use SFTP? In the meantime, has anyone attempted to us...