DSXchange

We are trying to come up with a datastage job which can study any other complex server job. For Example: To find the number stage variables used in a job. "DSGetStageInfo(hJob,stagename,DSJ.VARLIST)" function can be used in the Job Control to get the list of stage variables. Now my require...

I have to count the number of stage output link which has constraints.

ArndW wrote:Do you mean how many stage output links have constraints or how many rows go through those constraints at runtime? ...

Hi,

I have a requirement for counting the number of row level constraints used in transformer for a complex datastage server job. Kindly let me know if there's any way to get the count.


Thanks in advance

Sorry about using the word 'Urgent'. I understand this is a free service in one sense. But I did pay to become a premium member. I have derived unlimited benefits from this site especially from Ray which is beyond what I have paid. So I agree with Ray. Now can you please help give a direction as to ...

DS JOB OBJECTS I believe has all the data in it. But how to get the column count across all stages ? To get 3 parameters in a job I would say SELECT DS_JOBS.NAME AS JOB_NAME, EVAL DS_JOBOBJECTS."@RECORD<14,1>" , EVAL DS_JOBOBJECTS."@RECORD<14,2>" , EVAL DS_JOBOBJECTS."@RECOR...

Hi frnds..

I have a urgent requirement for Identifying number of columns being used in each stage in a server job. Any idea how can this be accomplished ?


Thanks in advance

Thanks to Ray's post. It made me explore various options...

After Job Sub-Routine : ExecSH

cd #SWorksOutputFilePath# ; awk -F, '{print > $2}' Sales.Imp ; awk -F, '{print > $2}' HistData.Imp

did it all

Col No. 2 in the file carries the filename.

Thanks to my collegue Gary ...

I need help here, please.

While reading a sequential file stage it allows to read from multiple files using pattern. What about while writing ?

I have got a source text file as follows ------------------------------------------- TargetFileName DataCol1 DataCol2 -------------------------------------------- ABC.txt 1 2 ABC.txt 5 6 ABC.txt 11 12 ABC.txt 41 24 DAMMY.txt 12 23 DAMMY.txt 34 45 DAMMY.txt 24 99 ... and so on... The number of Target...

Its same as server .. i.e :

Its same as server .. i.e :

Left(SourceString, index(SourceString,FindString) - 1) will give the left part of the string Right(SourceString, Len(SourceString) - (index(SourceString,FindString) + Len (FindString) - 1 )) will give the Right part of the sring When you combine these both using a : operator with your new string yo...

I used to work with Server Edition. One of my unit test tick off was to not have any warnings at all. Now I'm working in 8.0 Information Server using parallel Jobs. Cant have a job without warnings. Is it possible to do something about this ? So many types of warnings Eg. SA_STORE: Column NET_RETAIL...

Ray

I understand your point of pivoting. Assuming that we make the comma seperated list into columns. But the issue is the the number of input columns are varying. It can be 1 upto say 200 or more. I dont want to map into 200 columns..