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.
Search found 20 matches
- Fri Oct 31, 2008 10:26 am
- Forum: General
- Topic: Conditional Lookup to Hash File
- Replies: 5
- Views: 4098
- Mon Jun 16, 2008 1:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsjob timeout issue
- Replies: 5
- Views: 5777
Where can i find the Inactivity Timeout settings in 7.5.2
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
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
- Mon Jun 02, 2008 2:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error Importing Job in DataStage
- Replies: 2
- Views: 1824
Error Importing Job in DataStage
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...
- Thu Nov 15, 2007 1:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Char(250) or Space as Parameter to my job
- Replies: 2
- Views: 2095
Char(250) or Space as Parameter to my job
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...
- Thu Jul 05, 2007 3:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic File Layouts
- Replies: 4
- Views: 1859
- Thu Jul 05, 2007 1:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic File Layouts
- Replies: 4
- Views: 1859
Dynamic File Layouts
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...
- Mon Jun 18, 2007 11:25 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reusable Component
- Replies: 0
- Views: 1951
Reusable Component
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 ...
- Wed Oct 04, 2006 12:06 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Autosys and Wait
- Replies: 4
- Views: 3356
Autosys and Wait
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...
- Fri Aug 25, 2006 6:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TeraData API Lookup based on a flat file
- Replies: 6
- Views: 3623
- Fri Aug 25, 2006 3:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TeraData API Lookup based on a flat file
- Replies: 6
- Views: 3623
Hi
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
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
- Thu Aug 24, 2006 6:29 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TeraData API Lookup based on a flat file
- Replies: 6
- Views: 3623
TeraData API Lookup based on a flat file
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...
- Wed Aug 16, 2006 11:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Files Creation
- Replies: 11
- Views: 4339
- Tue Aug 15, 2006 8:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Files Creation
- Replies: 11
- Views: 4339
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 ...
- Mon Aug 14, 2006 6:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Dynamic Files Creation
- Replies: 11
- Views: 4339
Dynamic Files Creation
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...
- Thu Jul 20, 2006 6:31 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sum , Sort and Get Results
- Replies: 7
- Views: 3753