DSXchange

i didnt get u..what do u mean by none of them are compiling..yes we had issues when compiling transformers which had lot of code..but the requirements are so weird that we had to go for a c implementaion in build op. but there was some debate over using a buildop or making them as uder defined rout...

I think what "programatically" is meant in this case is during run time. What you are talking about is just a one time run to go and change a parameter in a file, synonymous to doing a sed operation(in unix environment) on the DSParams file.

I agree. Thats why I insisted on how the OP was going to change that environment variable. Use job parameters. Much safer and better implementation.

And none of them are compiling. Is that what you are saying?

Why dont you take a look ad the DSParams file in your specific project folder under Project directory and let us know what you investigated.

So everything in a straight line. Its going to be a very long line if you have huge number of records. You can use stage variables to attach, concatenate the columns and load it to a hashed file keyed on a dummy static key. Once your done. your hashed file will have a single line with everything con...

I dont think any order is necessary. These are environment varaibles. Open your datastage adminstrator, go to your project properties, click on environment variables. You will see a list of all the variables there. You can add and remove parameters there. You can add prompts there that can inturn gi...

Do you absolutely have to create a View to do that. No, you can load your dimension table into a lookup dataset and perform a lookup. You can also use Join stage and join the tables directly. I dont see any obvious reason for creating a VIEW.
My 2 cents.

What does your helloworld.c program look like. Can you paste it here so that i can compile and run it on my unix box and confirm whether the code is correct or you really are missing the "string.h" library.

You can put comments in the DSParams file in your project directory that will tell you what a particular parameter corresponds to. Its a variable. Variables have meaniful names for the very reason of identifying what they relate to.

You can use the DB2Load Stage. It has options to load partitioned database.

Have you tried getting rid of the column import stage and directly loading to the sequential file with quote character set to none and delimiter set to space ?

What does your input data look like. Give us sample date. Complete meta data also.
Just looking at what you gave us doesnt help us. On what basis is your code going to know that it has to stop pivoting and start afresh
What is the key for pivoting?

Use Decimal or Float depending upon the x and y values in NUMERIC(x,y). For each column it will be different and possibly same. But follow that. If you define it as integer, it will complain on the decimal point.

Thats unix style. Was hoping it would work on NT. Anyways, check out thiswebsite. It tells you how to build a NT ftp script.