DSXchange

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

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

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

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

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

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

We are moving to AWS, and the current discussion is around using Dell Boomi in place of DataStage. The discussion is still very early, so I have no juicy details to offer yet.

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

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

I'll describe a similar issue we had recently with the same symptoms. The DB is MSSQL Server, and I don't know if Oracle should handle this differently. We transmit up to 1,000 rows per day for an "upsert", except that the command line has separate queries for update and insert. Running on...

Rakesh,

Find the charts for the character sets, showing the characters and their hexadecimal values. Put EBCDIC and ASCII side by side.

I suggest finding older charts which stop at xFF or before. Extended character sets will get confusing after that.

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

rumu wrote:Can I use record delimiter and 'end' under record level while writing to sequential file stage as data type binary?

I honestly don't know. Try it, experiment, tell us how it turns out. I assume it will involve a transformer to do the padding.

I missed your question about the output column. I define one column sql type Binary (not Var), and leave the length blank. With no delimiters in your data, it will output as one continuous stream.

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