Search found 733 matches
- 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: 3669
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...
- 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: 3392
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 ...
- Thu Aug 05, 2010 1:40 pm
- Forum: Site/Forum
- Topic: Suggestion: separate forums for tech & design help reque
- Replies: 4
- Views: 5791
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...
- Thu Aug 05, 2010 1:25 pm
- Forum: Site/Forum
- Topic: Suggestion: separate forums for tech & design help reque
- Replies: 4
- Views: 5791
- Thu Aug 05, 2010 11:43 am
- Forum: Site/Forum
- Topic: Suggestion: separate forums for tech & design help reque
- Replies: 4
- Views: 5791
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...
- 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: 8751
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...
- 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: 8751
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...
- Tue Jul 20, 2010 8:21 am
- Forum: General
- Topic: Have I stepped on the forum etiquette toes?
- Replies: 5
- Views: 2028
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...
- Mon Jul 19, 2010 9:27 am
- Forum: General
- Topic: Have I stepped on the forum etiquette toes?
- Replies: 5
- Views: 2028
- Mon Jul 19, 2010 9:10 am
- Forum: General
- Topic: Have I stepped on the forum etiquette toes?
- Replies: 5
- Views: 2028
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...
- 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: 16007
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...
- 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: 16007
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...
- 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: 1155
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...