DSXchange

Hi all,
How to have a file name as the timestamp?

For example:
The file name should be
20070802213012.txt

hi,
y cant u try using a stage the update the lookup table after every iteration or b4 the lookup actually starts.

That should be an easy way i guess....

jus revert if there is anyother idea

The date gets converted to the datastage format, so that u may get the output in numeric format rather than as a date. SO u can use either iconv or oconv functions depending on your needs. Iconv- converts to the local datastage format i.e a number OConv- converts to the date format jus check out the...

The date gets converted to the datastage format, so that u may get the output in numeric format rather than as a date. SO u can use either iconv or oconv functions depending on your needs. Iconv- converts to the local datastage format i.e a number OConv- converts to the date format jus check out the...

Hi, Is there any certifications for datastage? if so what are the materials avlbl for it?


Thanks in Advance

Am extracting a set of details from three different tables and inserting them to a file. Now at the end of the file i need to add a record stating the numer of records and the status of the job.

can a routine be enough to do this?

I think ur job would be handling some null values. Thats a common scenario for this error to occur

Hi,
It ll be better to create a temporary table holding the info for the current run. So that whatever changes u can retrieve it from the temporary table.

Note: Everytime you run jus truncate the temporary table and re-run it so that oly the current details will be there in the table

Hi,
It ll be better to create a temporary table holding the info for the current run. So that whatever changes u can retrieve it from the temporary table.

Note: Everytime you run jus truncate the temporary table and re-run it so that oly the current details will be there in the table

Thanks.

Hi,
I suggest u to pass the premium as a parameter to a stored proc through OCI stage. Then write your business logic based on the parameter number. i hope this meets the requirement

Jus pass the error message back with a variable. Then try inserting the variable to the required table.

Hi,
Can anyone tell me whats the code to FTP using a routine in datastage? Also the file that is FTPed has to be archived.
Thanks in advance

Hi All,
How to view the datastage error log from administrator?

I got a job which prompts for the day of run... If no value is passed it should take the previous month's date... how to get that??