DSXchange

Ray,
Thanks for th reply.
But When we load the columns for the table,we used the table definition.
So is it possible to find the table name by using the DS_METADA for where the table is used in the jobs.
Please guide me on this.
subbu

Hi All, I need to find the table used in the all the jobs.Also as i am using the parameter for table name,I need a query to list the table name through DS_JOBS,DS_JOBOBJECTS and DS_METADATA.Please help me on this.

All,
I want to do a "trim" in modify stage ....Please do guide me...
subbu

Hi ALL,
When i executed a parallel job it was sucessfully.
But when i try to run it in sequencer it gave a fatal error like "main_program :ORCHESTRATE step execution terminating due to SIGINT"...


Please do clarify?

Thanks..
sp

Hi All,

The source file( .xls) is in UNIX SERVER and i want to invoke it in datastage designer.

Can you please give a solution for this..


Regards
Subbu

Hi All,
The input is string ( the format is in within double quote "2006") and i need an output in integer( example: 2006).
How can we do it in Datastage Designer?
Please do help me to solve this....


Thanks and regards
Subbu

Hi,
I have 200 rows and i need to import the 95 rows to my source (all are in text files).
So how can i avoid first five rows to sourch while importing...

Can you please help me to solve this

thanks

Subbu

Hi, I checked the Server Name and it is correct. And now i got an error like "SMTPMail Failed to open message file. Error 2" My question is where we have to set the message file in the dssendmail_template.txt cheers subbu Subbu, Try to ping the server from the \bin directory to see whether...

Hi All, When i am trying to execute the Dssmtpmail.exe from command line ,i got a message like " Unable to locate the server " C:\Ascential\datastage\enging\bin\dssmtpmail.exe -server servername -subject "hi" -message "file" mailid And also i have clearly mentioned the ...

Hi All, When i am trying to execute the Dssmtpmail.exe from command line ,i got a message like " Unable to locate the server " C:\Ascential\datastage\enging\bin\dssmtpmail.exe -server servername -subject "hi" -message "file" mailid And also i have clearly mentioned the ...

Import what from where? There is not enough information in your question for a meaningful diagnosis to be attempted. ... Hi Ray, When i try to import the text file (sample.txt) in the server job, i got the error. i.e "Sequential file stage ----> Table Definitions ----> Import Meta Data(Sequent...

Hi All,
When i try to import , i got the below error

" DSR.Metadata: Cannot read result file DS-MetaTemp record METAGETA-3368 from GetMetadata"

Hi Kumar, I applied the PWD variable and set the path.But this time i got an error like the below one. Could u plz give a solution > Output from transformer compilation follows: ##I TFCN 000001 15:06:42(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 ...

Hi All, I got an error like the below one. Can u guys solve this plz? Output from transformer compilation follows: ##I TFCN 000001 09:15:21(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TOSH 00...

Output from transformer compilation follows: Hi All, I got a error in parallel Transformer like PWD environment variable not set..Can u people clear this doubt? ##I TFCN 000001 09:15:21(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Softwar...