DSXchange

Actually the soruce projct from which I copied, already has this problem. When I try with other project which has good index, it works fine. Even when I try to Delete the index, it give me 'File "DS_JOBS" has no indices.' I am doing export/import since morning. (Sick and tired of it) Just curious to...

chulett wrote:Man, I really should stop posting first thing in the morning.

Just the one after 5000 sucessfull posts should stop you.

ArndW wrote:The files are RT_BP{nn} and RT_BP{nn}.O

So shouldnt the error be poped out as 'Cannot open RT_BP{nn} and RT_BP{nn}.O'?

If you need to read only first line of the file, you make use of 'Read first n rows' option available in the Sequential stage and set it to 1. Interesting. In this thread people claim there is no such option. The issue with the provided link is to skip first n rows, where as here, its to read first...

May be possible if dont really want to stick with Sequential stage. And the provide the input file is Sequential Flat file. You can use Head stage. Where you have option to 'Skip n rows per partiton. Also that you have option to read N rows. Also make sure the partion is made to single. Either by Fo...

It this should be under any sub directory?
Because it does not give any output for 'ls B*' under project directory.

Have you checked the link.
This option has been tried by the poster in the transformer.

If you need to read only first line of the file, you make use of 'Read first n rows' option available in the Sequential stage and set it to 1. If you need the name of the file in the same stage as another column, then you can make use of 'File Name Column' option avialable in the sequential stage. I...

To the last post : it is a root installation. Anyway, managed to login through TCL --------- cd $DSHOME bin/dssh >LOGTO ABC --------- Did a DS.TOOLS and selected rebuild indexes repository. Restarted datastage; and now I am able to connect to the server. Suspected that the indexes were corrupted by...

Someone probably did rebuld indexes in DS.TOOLS. If a user is connected then it will delete the indexes but not build them. It needs exclusive access to all repository tables like DS_JOBS in order to build the indexes. Try DS.TOOLS again with all th users out of Designer, Director and Manager. This...

You can set the value in the transformer.
Pls check this link

Welcome Aboard :D
What is the main purpose of the batch job. Is it just preparing the parameters for the underlying jobs or call the jobs.
If so search for DSRunJob and DSSetParam.

You have many option to acheive this. I guess the first sequence would populate the table. And you need to avoid running rest of the sequce if the table doesnt geting populated. You can check the DSGetLinkInfo for the link which the table is getting loaded and if that is greater than zero you make y...

Though you assign a new value to the variable, it will not be reflected to the rest of the job using the variable.
The Main sequence which holds the variable while getting triggered will hold the value till the last and supply to all the jobs which it calls it.

Not sure why this happen. May i know the syntax to build the index. When I tried the follwoing it gives me as shown. >LIST.INDEX DS_JOBS ALL File "DS_JOBS" has no indices. >CREATE.INDEX DS_JOBS JOBID Index field JOBID is a duplicate of JOBID, no new index created. >BUILD.INDEX DS_JOBS JOBI...