DSXchange

I have created a look up file set with 10 records all having same value for the key column and "Allow Duplicates" is set to TRUE in the look up file set stage. In a second job i am having a single row in the source file and then followed by a look up stage whose refence is the above look u...

yes craig - we are trying to do that from now on but for the current analysis we have hit a dead end

If i wish to view the data that lies inside the lookuptable file created by a lookup file set, is it possible ? There is no view data option too :( it gets tough when analyzing an issue where one wants to see what values were contained in lookup table, though i can go to the source which was used to...

disable operator combination for the transformer stage and recompile and post the result

the most recent thread should give me exact resolution

did any one come across "serialization" in datastage ? Does any database stage have serialization facility ? I was surprised whe he spoke regarding serialization over just sequential files . (File to file process) I am running on 8.1 version not sure if this has been added in the later ver...

some one tested me with the same question and I gave my mentioned views but the opposite person had a different solution. He made reference to a term called "serialisation" where data entries are consistently made into memory. Not sure what he was talking about, never came across such thin...

Why not log into Datastage administrator and run the query there ?

b> if i execute create .file statement again will other sequence will be effect (i.e when jobs run.. sequence will start from 1st or will it be start from old sequence no:). if you are creating the file then you dont have to get it from other environment. Yes your other sequences will be effected, ...

can you share the expression as you have mentioned in the range look up stage ?

Whe i just moved into datastage had this issue and did not know how and which file to move and from where.

fixed the situation by copying the code of the routine and modifying it to update with the value passed as argument instead of applying " + 1 "

it would apply to the whole file, what if any other column is single quoted ?

the term "future" has to be clarified here. is this a one time stuff or supposed to run in production on a daily basis, if so then is "future" something that is greater than the run date ? Since you using a two digit notation for year, also take care of the century break year whi...

in such case it should be a signed column and you dont have an option but to change the datatype to bigint or atleast change it to unsigned if you dont expect negative values

One cant park a truck in a garage designed for a car

I need convert them to DD/MM/YYYY. What is your target, change of format only makes sense if your target is sequential file Please can any body tell the functions need to be used in converting date format and check the date ISv alid There are no functions to change the format of date value that exi...