DSXchange

If you look at the file in an editor, is it actually fixed width?

Please have your DBA check the foreign key FQA551.

If it is any consolation, my initial answer was identical to yours, but I managed to edit it quickly...

Sainath, upon re-reading the post I think your interpretation is better than mine

Try making the lookup file set write stage "sequential" - that forces a 1-node configuration. My guess for your problem is that a 2-node Lookup fileset cannot be converted to a 4-node "entire" lookup fileset; but I'm just make an uneducated guess since I haven't seen that error m...

No. DataStage is not legally downloadable for free off the internet. You can get free test licenses through IBM or their local distributor for DataStage, but that is at their discretion.

Move all your TRIM(link.column) to stage varaibles, that way each distinct TRIM() is only executed once and not several times as is now the case. That will reduce the CPU load somewhat. During execution, turn on the monitor and display the %CPU -> if the value is anywhere consistently below 80% then...

Hmmm... you are most likely correct. But would presuppose that your lookup file set was created with just one partition, is that the case?

to answer your second question: "no" (otherwise it would have been suggested). A very unclean method would be to clear all log files from TCL (a couple of commands); but since this is your production machine there might be a lot of repercussions to doing a "tabula rasa".

Craig - he means take the value of a variable as a variable name and assign that variable's value; sort of a like a variable being a pointer to the value of another.

chulett wrote:Sorry... "extra" columns?

By that I mean that while the link might show 10 columns, if RCP is turned on there might be additional columns going down that link; those would be the "extra" columns.

I can't check right now, but I think it might be that lookup filesets, unlike datasets, cannot be dynamically repartitioned. Is this inded a fileset and can you check via orchadmin whether the fileset partitioning is identical to the runtime partitioning?

Could one of the links be using RCP and have "hidden" columns?

If you search the web for a freeware program that does this on your platform, i.e. one that accepts a number as parameter and returns a string representation, then you can implement it via a shell script. Note that if performance is a factor then you will have to use a c++ call.

That functionality doesn't exist in BASIC, one can use "LIT" for constants, but those are evaluated at compile-time and not run-time. You can work around the problem by using an array or dynamic array. e.g. Variables = '' Variables<1> = "test" Variables<2> = "1" NewValu...