DSXchange

Anybody can guide me to calculate storage required for working files? What to consider for calculating disk space required for staging, temp, hash, reject files etc. I also want to know space requrements for each project. Please send back any questions, if my inquiry is not clear.

Thanks for your help. Let me check cron jobs.

The original post is for windows. I searched the knowledgebase and replied with a question for Unix. I'm Sorry!! my OS is Unix.

What scheduler it uses on Sun unix? Is it Cron?
Thanks for your reply.

Oh.. ok. I ran it @ win 32 command prompt.
It lists only windows scheduled jobs.
All my DSjobs are scheduled in DS director.
Is there a way to list all scheduled jobs in my DataStage project?

I am getting "Illegal verb -AT" message.
How can I list all the scheduled jobs in a project?

I used convert function. It works. But, we need to list all the unwanted characters.

FYI:
Becuase I need ALPHA and DIGITS (alpha numerics), we can not use the 'MCA' or 'MCN' formats with Oconv. Same with "LETTERS" and "DIGITS" built-in transforms.

thanks for all the help.

Hello!
How to filter all non-alphanumeric charaters from a srting. (filter space,/,-,* etc).
Is there a option in oconv function for this? or any other transformation function available for this?

Input string:
'SY-002-1|SALINAS-E Boronda Rd/San'
Result:
'SY0021SALINASEBorondaRdSan'

Thank you

I have not used the @INROWNUM, @OUTROWNUM in the solution to this problem. Instead, I have created a routine to open the unused number hash file and return the first number with every call then delete that number from hash file. This is very simple approach, but don't know why I could not thought ab...

When you use "iconv" on a date it will be converted to an integer (which is called internal (format) representaion of a date in DataStage)

Thanks.

Step1: Create a hash file (MyHash) with three fields: 1. Id -- Hard code this value with 'XYZ' 2. Date1 - integer - store your 1st date in the internal format (use iconv) 3. Date2 - integer - store your 2nd date in the internal format (use iconv) Step2: Do a look-up to Myhash with key expression = '...

kcbland ,
Will you be able to explain this again? I could not make @OUTROWNUM work for me. It gives sequence numbers.
What should be in key expression?
and what is the derivation?
Thanks
-Kud

I am not quite understood about using @OUTROWNUM.
Can you explain it again? How to do lookup and what we write in the derivation?
Thanks

Thanks for all your great ideas. I didn't know that server job works without input. rownum also works great.

I will be very happy if you guys can help me on how to fetch unused numbers one at time (like stack). Also how do I delete the number after using it from the file?

Thanks for all your help.

Yes it is vey slow. On the other hand we do not have any big table.

If I am success in building unused number file, how to fetch each number to assign it to my record? How to build stack mechanism in to data stage?
Looks like I am lost.