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?
kduke wrote: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)
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
kcbland wrote: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?