How to Capture File Name from Sequential File Stage

[poorna_76]

Code: Select all

select 
   EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '45L',
   DS_JOBS.NAME AS JOB_NAME FMT '35L', 
   DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L'
from 
   DS_JOBOBJECTS, 
   DS_JOBS
where 
   DS_JOBOBJECTS.OLETYPE in ('CSeqOutput','CSeqInput') 
   and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO 
group by 
   FILE_NAME, 
   JOB_NAME,
   LINK_NAME
;

Hi Duke,

Sorry for posting in the same thread.


When i execute a command/ run a query (the above query you posted) through DataStage Administrator, how can i capture the Output to a file/printer?


Thanks in Advance.

[kduke]

You have to make the SQL all one line if you do it this way. The results can be copied with normal Windows cut and paste commands.

[chulett]

Don't forget the magic words! "PTERM CASE NOINVERT"

[poorna_76]

You have to make the SQL all one line if you do it this way. The results can be copied with normal Windows cut and paste commands.

Hi Duke,

Let me tell you what i am doing?

In DataStage Administrator, selecting the appropriate Project and clicking on "Command" button.
At the Command prompt , i am executing the above query in single line and the results are displayed in CommandOutput.

When the results are displayed in CommandOutput,
it does not allow me either to select the results/ do any Windows cut & paste. (This is happening for anything i execute at the Command prompt in DataStage Administrator)

Thanks in Advance

[kcbland]

You have to use the TCL prompt in a telnet session. You need to change to the DS engine directory. Enter ". ./dsenv" to put the environment file into your environment. Then, either "bin/uvsh" or "bin/dssh" depending on your version. You're now in the engine shema. Type "LOGTO yourproject" case sensitive. Now you can enter project (schema) commands like Kim has provided.

[poorna_76]

You have to use the TCL prompt in a telnet session. You need to change to the DS engine directory. Enter ". ./dsenv" to put the environment file into your environment. Then, either "bin/uvsh" or "bin/dssh" depending on your version. You're now in the engine shema. Type "LOGTO yourproject" case sensitive. Now you can enter project (schema) commands like Kim has provided.

Thanks, Kenneth Bland.

I am on Windows environment running DataStage 7.5.1A.

Can you please tell me, clear steps on how to execute these queries using the TCL prompt. (on Windows environment)

I tried the following and was unsuccessful:
********
open ServerName

Welcome to DataStage Telnet Server.
Enter user name:
Enter password:

When i entered username & password (correct) i got following messages:

Unable to attach to the given directory.

DataStage telnet session terminating...

Connection to host lost.
************


Do i have to be an Administrator, to run these queries?

Thanks in Advance.

[ray.wurlod]

Your home directory must be a DataStage project, or your startup script must attach you to a project directory.

[chucksmith]

Take a look at my List all files and tables used by jobs in a dsx file tool.

You will find it on the DataStage Tools page of www.anotheritco.com.