DSXchange

I came up with this script. Is it good?
number=1
while [ $number -le 100 ]
do
echo $number >> a.txt
number=`expr $number + 1`
done

Thanks

Creating pre-generated file containing numbers in a column from 1 to the max number has become a challenge for me.
Any ideas? Can we make a simple sql stmt that return 1 thru max number?
Or any shell script?
Please share any ideas.
Thanks.

kcbland, You are correct. I am trying to find the unused numbers. The system is AS400, we are using Oracle plug-in to bridge to it and read AS400 files. What is the method to prepare a list of unused numbers? As ray.wurlod said this does not make any sense to handle this problem in datastage, but cu...

The file consists of one column of unique numbers.

The routine has to return a number that is not in the file.

This may be crazy. But, I am trying to solve the following problem. This is what I need to do: 1. I will call a routine from DataStage passing a number (int1) 2. The routine has to open a seq/hash file consisting of numbers. 3. check if "int1" is in this file. 4. If not found, return "...

Thank you.

Sincerely,
Sri

Where can I get user guide for QualityStage? Anybody has a pdf file of this? I want to learn QualityStage. Please help.

Where can I get user guide for QualityStage? Anybody has a pdf file of this? I want to learn QualityStage. Please help.

Good news! It is working. I have modified it a little bit. Takes job name/batch name as a parameter along with job seq name. Thank you. Here is the code: * ------------------------------------------------------------ * RtnStopJobOrSequence(Job Or SeqName) * ------------------------------------------...

Let me ask something. By stopping a job sequence does it stop all server jobs as well as job sequences under it?
My master sequence job as grand grand children of type job seq.

This does not seem to work if JobSeq calls another jobSeq calls another ...
Do you think we have to call this recursively? I'm still working. Let me know your thoughts.
Thanks.

or do we have to query each dependent separately for it's type?
How to see the DS_JOBOBJECTS table definition?

openpath EdwHashFilePath : '/':PeriodHashFileName to periods.h else goto FileWarn

SELECT periods.h
READNEXT @ID Else Goto NothingToProcess

READ PartRec FROM periods.h, @ID Else Goto TheEnd
PeriodToLoad = PartRec<1>

Thanks. I will see if it works. will come back with answer in 2 or 3 days.

Can write the input and expected output data here?