DSXchange

Hi Guys,

I need to capture File Name from Sequential File stage by any means. Its little tough because I am not passing the file name as parameter it's hard-coded along with path. Any info will be appericated.

thanks,

Hi,

Are you saying that you have to capture the filename from the path name?

For ex:

If thats the case, then you use the DCOUNT function to count the delimiter "\" and then use the FIELD function to extract the last field which is nothing but the filename .

Let me know how it went.

Thanks!
Naveen.

There is no API for requesting such information. The only thing you can do is trick the job into telling you this information thru the job log, which you can then query using the API DSGetLogSummary. Unfortunately, most of those messages tend to be fatal.

I think you need to revisit why the file name is not parameterized and shared with other processes. Your task is most difficult.

kcbland wrote:There is no API for requesting such information. The only thing you can do is trick the job into telling you this information thru the job log, which you can then query using the API DSGetLogSummary. Unfortunately, most of those messages tend to be fatal.

I think you need to revisit why the file name is not parameterized and shared with other processes. Your task is most difficult.

The job log doesn't tell what is the output file name that you have defined inside the stage....

Hardcode the filename as the stage name, then get the stage name with DSGetStageInfo.......

manteena wrote:Hardcode the filename as the stage name, then get the stage name with DSGetStageInfo.......

Cheater, I assumed the file is fully qualified and stage/link names can't have slashes, dashes, dots, just underscores.

dilsere2 wrote: The job log doesn't tell what is the output file name that you have defined inside the stage....

It does if the file to be opened can't be opened, or there's some other catastrophic issue, hence my reply that the file name only shows up under tragic circumstances.

kcbland wrote:

dilsere2 wrote: The job log doesn't tell what is the output file name that you have defined inside the stage....

It does if the file to be opened can't be opened, or there's some other catastrophic issue, hence my reply that the file name only shows up under tragic circumstances.

Tell what you think of this? After job is sucessfully completed i will write a BASIC codoe to export the file to get dsx file name then write script to pharse out the FileName...You guys have any other ideas...

Why does this sound like a variable value everytime the job runs, but is hardcoded? This makes no sense. Is someone changing this filename, compiling it, and running it? Can you at least get them to write it to an empty directory and then assume anything in that directory is the file you want?

An XML job report will give you the file name with Directory name of the source or target file stages....try to read this report for filename...

NO CHEATING

manteena wrote:An XML job report will give you the file name with Directory name of the source or target file stages....try to read this report for filename...

NO CHEATING

You might just have the winning suggestion! :D

In addition to Kim Duke's SQL statement, add jobno filter in the WHERE clause to give you the file name for that job, which you are looking for.

HTWH.

Regards
Saravanan

elavenil wrote:In addition to Kim Duke's SQL statement, add jobno filter in the WHERE clause to give you the file name for that job, which you are looking for.

HTWH.

Regards
Saravanan

This is an SQL statement..how do i do this in Datastage?

Do a search on TCL commands and telnet.