DSXchange

Hi,

I want to fetch the max value from a table and use (max+1) as the satart value field in a surrogate key generator stage.

I thought of writing a script which retrieves the max value.

But how can i pass this value from script to the job?

Thanks,
Savis

Hi, Is there a way to generate columns dynamically? If suppose, i have input files like: file 1: col1,col2,col3,col4 file 2: col1,col2,col3,col4,col5 file 3: col1,col2,col3,col4,col5,col6. If the datatypes of all files are same, then can i use a single job for handling all the three input files? ple...

Hi,

I use the follloing command to export all the jobs in my project..

dscmdexport /H=%DSSERVER% /U=%DSUSER% /P=%DSPWD% %DSREP1% %BACKUPDIR%\%DSREP1%".dsx"

Is there a way to export jobs in only one category(not the entire project)?

Thanks in advance,
savis

Thanks..

thanks.. It worked..

Can i replace the '^Z' character with space?

Is there a way to do it?

Hi,

Is there a way to detect the presence of '^Z' character in a field.

I tried using count() function.

But it is not detecting.

Thanks in advance

Savis

Hi,

I remember reading somewhere that if the size of the lookup file is too high, the performance goes down.

Instead can you use join?

Thanks,
Saranya

Can you try this way? Multiply the field by 10000 (say x) or some other value and try to store in some datatype. when you reterive, divide the field by the same number (x) . I do agree that this will have negative impact on your performance? If you find any other better solution, do post it.. Thanks...

Hi, hope this helps... A terminator stage can be placed in a job sequence to ensure that a job is stopped cleanly if ther are fatal errors. 1) use a job activity stage and select the expression type as failed 2) use a terminator stage and stop all the other subordinate jobs if required.. Thanks, Savis

Hi, Did you use this function: DateFromDaysSince(7,StringToDate(<Date Field>,"%dd-%mm-%yyyy") ) Input output 01-01-2008 2008-01-08 11-02-2008 2008-02-18 01-03-2008 2008-03-08 21-02-2008 2008-02-28 01-02-2008 2008-02-08 05-01-2008 2008-01-12 03-02-2008 2008-02-10 05-02-2008 2008-02-12 Thank...

Hi, I used the following design: seq file ---- transformer-----seq file My input was like 1|2|3 4|5|6 7|8|9 11|12|13 14|15|16 17|18|19 In the first seq file, I didn't not specify any end delimiter or field delimiter. In Transformer, I used two stage variables for doing this task. Ist stage variable:...