DSXchange

Hi, You could also use a pivot stage. Key on your Branch Number, and if your account numbers are always 8 characters long, then create 10 output columns using substrings to represent the account codes, which will become your 10 output rows for each Branch Number.

Thanks for your replies, I'm sure you can use the hostname or the IP address, I've testesd this and I get the same error. Since my last post, I remembered I had to try to use bind19 to bind a package for my new DSN, which seemed to work, but still I can't connect. I'm waiting for my DB2 DBA to retur...

Hi trokosz, Thanks for your reply. Yes, I named the entry in .odbc.ini as MERCURY. I have used one of the examples as a template for my MERCURY entry. This is what I have: [MERCURY] Driver=/dstage/Ascential/DataStage/branded_odbc/lib/VMdb219.so Description=MERCURY Database AddStringToCreateTable= Al...

Hi everyone, I'm having problems trying to set up an ODBC connection for DB2 on AIX 5.2 I have read the documentation, and searched for a few hours on here. (We currently use the DB2 UDB plugin with no problems whatsoever) I have set up the following: 1. Added entry into uvodbc.config in the project...

You can run a shell script containing the following:

(uuencode /WorkingDirectory/Source.csv Target.csv ) | mail -s "Email Subject" whoever@acme.com

Excellent, I'm glad you solved your problem!

Hi,

For link collectors, my understanding is that you need to have sequential files (or hash files) as your source and targets. You will get an error if you try to collect your data in a transformer. This is probably the source of your error.

I had a similar problem, but never resolved it. I was going to contact Ascential support about it, but a business decision was made to not use XML to move data around on the project I was working on, so my problem was left unresolved. Have you contacted Ascential about this? I would be interested in...

Hi,

You can export the job as XML, and on the record identifier tab, change to ReadOnly = '0'

You should really be using version control for moving jobs from development to other environments. All other environments should be read only (UAT, SYS etc)

If you want to use Oconv, create your own routine using:

Ans = Oconv(Arg1, "MCA")

Thanks everyone, I didn't expect so many replies
For this problem, I have until Q3 next year to play around, testing the various ways of doing this (this project is on hold while I work on another one).
I will start on the multi-instance job route, with looping job control.

Thanks guys for your comments so far. Tony, unfortunatley we don't have 7.5 yet, we are running 7.1 r1
I'm assuming by a BASIC job you mean some job control code that runs my job, and somehow loops through the BU's to write to the correct table? DS BASIC is not one of my stengths

Hi, Some help and advice on the following would be appreciated: I have one job, I want to be able to output to multiple tables dynamically based on a value in a field. The target is AS/400 files (tables), all have the same metadata. Example: Business Unit (BU) holds 8 distinct values, I want to outp...

Is it possible, using the DB2 plug-in for DataStage, to Access AS/400 Multi-member files? I want to be able to read or write to this level. If not, is it possible any other way, or with a future DB2 plug-in? Currently I only see: LibraryName.FileName I would like to see: LibraryName.FileName.Member ...

Hi,

You must output to the target database in DataStage internal format. For example, if your input date (Arg1) is in the format YYYYMMDD, then use the following in a routine:

Ans = Iconv(Arg1, "D-YMD[4,2,2]")