Search found 733 matches
- Tue May 21, 2019 11:37 pm
- Forum: General
- Topic: Retiring, but never shy
- Replies: 4
- Views: 4444
Retiring, but never shy
I've officially set my retirement date here at June 21st. I wanted the group to know so you won't wonder why I've disappeared. There are others here who will show up sooner or later. I've been promoting DSXchange for a while. I've had a great run. I've received invaluable help and advice here, and c...
- Wed May 01, 2019 10:45 pm
- Forum: General
- Topic: Export job designs with executables (where applicable)
- Replies: 4
- Views: 4426
We sometimes use the same .dsx file for the PRD elevation after verifying it in SAT or CAT. Below PRD, all of our exports and imports are done manually using the appid on login. Our PRD environment is restricted to automated functions using the appid as owner of the processes. For this and other rea...
- Wed Apr 24, 2019 2:42 am
- Forum: General
- Topic: Administrator interface updates via command line
- Replies: 6
- Views: 4821
The code I posted is out of the context of the script we use. Unfortunately, I can't post the rest because it's proprietary and not my place to share it. I've not looked at the IBM documentation of the admin functions in too long, about 1,000 cyber years ago when we were using 7.x. If one of the fun...
- Tue Apr 23, 2019 2:36 am
- Forum: General
- Topic: Administrator interface updates via command line
- Replies: 6
- Views: 4821
Your English is quite okay. We use a command line via a scheduler job (Control-M), and the script we use is dependent on a project ssi file that contains the environment variables and their values. To add our update, we modify the ssi file and run the script. Sample command lines: ${DSHOME}/bin/dsad...
- Tue Apr 16, 2019 2:41 am
- Forum: General
- Topic: Export job designs with executables (where applicable)
- Replies: 4
- Views: 4426
My reply is generic in the sense that this is how we see it in our shop, and you might find value in it. The production environment is set to read-only. When we have a production incident, having the Designer code in place is a great aid to determining the incident cause. Director messaging is not g...
- Wed Mar 13, 2019 7:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF - occurs depending on clause
- Replies: 1
- Views: 2750
The FAQs at the end of my post will give you more general assistance with COBOL/EBCDIC data. The latest wisdom from IBM references version 9.1, but it might still be true. https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_9.1.0/com.ibm.swg.im.iis.ds.mfjob.dev.doc/topics/r_dmnjbref_Using_a_Comple...
- Wed Feb 27, 2019 3:53 am
- Forum: General
- Topic: DataStage on Cloud
- Replies: 2
- Views: 3836
- Fri Feb 01, 2019 6:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel DataStage Jobs Hanging Intermittently - Oracle?
- Replies: 11
- Views: 9777
d-woo, I understand your frustration very well. We were lucky in that the app is very small and has a maximum data volume of about 5,000 records. We don't need more than one node. There should be an environment variable which you can use in each job that needs to run on only one node. I don't know h...
- Mon Jan 28, 2019 9:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Flat File very long filler processed as "raw&qu
- Replies: 0
- Views: 2591
Complex Flat File very long filler processed as "raw&qu
We likely have a workaround, so this is a request for any similar issues people have seen and whether they determined if it was worthy of reporting to IBM. I tried a few searches for previous posts on this, but found none (likely because I'm just bad at searches). The copybook defines a record of 2,...
- Mon Jan 28, 2019 6:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel DataStage Jobs Hanging Intermittently - Oracle?
- Replies: 11
- Views: 9777
- Fri Jan 04, 2019 7:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort as EBCDIC
- Replies: 7
- Views: 6035
- Thu Jan 03, 2019 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort as EBCDIC
- Replies: 7
- Views: 6035
It's an easy mistake to make when processing EBCDIC character set data in the DataStage ASCII character set default environment. The setting you see is how you control that. Sorting is on the binary data which represents the characters. The main difference between the character sets are the numerals...
- Thu Dec 13, 2018 1:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read Binary file from AS400
- Replies: 9
- Views: 7438
- Thu Dec 13, 2018 12:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read Binary file from AS400
- Replies: 9
- Views: 7438
- Thu Dec 13, 2018 11:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Read Binary file from AS400
- Replies: 9
- Views: 7438
Try the following: FTP Enterprise: Source -- URI = ftp://#ftp server name#/'#[fully qualified file location and name]#' Connection -- Password = #password parameter# User name = #user name parameter# Transfer Protocol -- empty, FTP is default Sequential File Format tab: Right-click on Record level a...