DSXchange

RCP will not work with flat files, need a relational source.

Yes, thanks for the resolution, on AIX 8.1 you use a similar method, with a comma separated config file. I had the added joy of setting a project defined parameter. $ dsjob -file myfile.pas server:9080 server -run -param '$stageusr=paramuser' Project Jobname $ cat myfile.pas server:9080,server,user,...

I assume you have xpaths defined for each of these columns? Please can you post them? Including named spaces (NS1:) in your output can be tricky, so you have to be pretty specific at what you're trying to achieve. Setting your "code" column as the repeating group column should resolve your...

This looks like a problem with your reject link. Why dont you output everything from your lookup into a transformer and handle your exceptions there?

Using DB2 you can issue the following:
This will either fetch 1 or no rows. Usings Ray's lookup technique, you can generate a single row into a lookup and try to get a match and fail it if not.

Ok, you need to direct the output of you tar to a named pipe. So create a named pipe called "np" by doing the following: mkfifo np When you're ready to run the job, simply go: tar -xzf xyz.tar.gz xx.tsv > np In datastage, your sequential file is called np and the data should stream through...

where can i check the C licence dates. OK here's a quick test: login to DS Administrator and get your C compiler path from your Environment variables. It should look something like: /usr/vacpp/bin/xlC_r At unix login as dsadm and vi a dummy program e.g. hw.C #include <stdio.h> main() { printf("...

Have you checked your C licence dates?

An example of your output data here would be useful. If you simply require varchar to be quoted and numerics to be not in a sequential comma seperated file then set the quotes setting to " Alternatively you could simply have 1 output string a varchar 9999 for example in which you construct your...

An example of your output data here would be useful. If you simply require varchar to be quoted and numerics to be not in a sequential comma seperated file then set the quotes setting to " Alternatively you could simply have 1 output string a varchar 9999 for example in which you construct your...

Dont worry about variables beginning with 2, the logic reads:

StageVar1 = if CustID[1,1] = '1' then DSLink1.Address else StageVar1

StageVar1 will be persistent so you can access previous values.

Mine is under the path:
C:\IBM\InformationServer\Clients\Classic

You can use a stage variable to capture previous addresses, so you can have something like:

if CustID[1,1] = '1' then DSLink1.Address else StageVar1

simply populate your output column with StageVar1

This assumes data is sorted in the correct order of processing.

Your logic is fine

If you unzip directly into a named pipe, you can read it directly as a sequential file without landing the data.