DSXchange

Hi Kris,

I had a similar case ... and was looking at your suggestions.

However the job is not able to read the hash file and gives the following error

SQLSTATE=S0002, DBMS.CODE=950390
[DataStage][SQL Client][UNIVERSE]DataStage/SQL: Table "hshfilename" does not exist.

Hi,

I am facing this similar problem and am not sure how to set the Inactivity Timeout settings.

Looked up in Administrator General Tab, but could not find it.

Thanks,
Sam

Hi, I am trying to import a job in DataStage through Administration and am getting the following error Cannot open executable job RT_CONFIG I killed the unix process through which i was trying to import the jobs and tried again but i gives the same error. Not sure what else i need to do. Please advi...

Hi , I want to create a parameter named Filler in my job and pass a value of Char(250) non printable character or Space . Depending upon whether the filler parameter is a char(250) or a space i need to populate my output columns. Example If i have 4 columns in my output sequential file and 2 of thes...

how about if it is a normal file and not a fixed width file

hi, I am using datastage to create sequential files.This is a fixed width file with 8 columns as follows EmpNo,FrstName,LastName,SSN,DeptNo,PhoneNo,Address1,Address2 This is a standard job that i use a number of times.Most of the times the layout remains the same, in certain cases i have to change t...

Hi, We are creating flat files through Datastage , wherein we get requirements sometimes to select 10 columns from table abc,sometimes select 12 columns from table abc etc.In other words same columns from same table get repeated multiple times in different jobs. I am looking out to create some kind ...

I have a Autosys job which kicks off on 10th of a month.It may take a day or 2 to complete some datastage cycle. Once this is completed i have another job which should kick off after 7 days of completion of datastage cycle. I have to setup a dependency in autosys such that if the datastage cycle com...

Hi mcolen,

I am doing exactly the same.

Please refer my sql above...

I have passed all the other parameters as required like to userid id , password , server etc....
I have also mentioned that i am using user defined sql option.

Sam

Its a user defined sql.

To explain once again..

The flat file suppose gets an employee no 20. I then lookup to teradata running the following query, and try to get the Salary back.

Select EmpNo ,
Salary
from Employee
where EmpNo = :EmpNo

I also tried substituting :1 but it didnt work.

Sam

Hi, I have a flat file with EmpNo and DeptNo. I am doing a lookup on teradata API based on EmpNo and try to get salary. The API has the following sql Select EmpNo Salary from Employee where EmpNo = :EmpNo The lookup however fails with a message Cannot use value (or macro parameter) to match EmpNo Wh...

Thanks to all you guys for the suggestions.

That did solve my problem , except that ,if i have a header in my original file and i want to ensure that the header is part of all the sub-files that are created , how do i do that

Hi DSGuru!!! Thanks it worked great. There were however some minor problems which i want to get clarified Here is the file myfile.txt i created ab cd 10 100 10 50 20 30 10 40 10 50 20 60 srt.sh sort myfile.txt | uniq | awk '{print $1}' > filenames.txt cat filenames.txt | while read FileNames do cat ...

Hi, I have a file with data in the following way Employee Sal 10 100 10 200 10 40 20 400 20 20 20 10 20 100 I want to create files dynamically based on the employee number . In the above case the output should be directed to 2 different files one for each employee. I do not know the employee numbers...

I just receive a flat file which has data in the above format...so i need to carry the above operations in datastage.