Search found 16 matches
- Wed May 10, 2006 5:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine processing file
- Replies: 4
- Views: 1860
Routine processing file
Hi, I am trying to write a routine that suppose to receive a file and process it line by line. Each line saved in a comma seperated file. For example, Source File: Line 1: account 9876 Line 2: finance 5432 Line 3: premium 1098 .... comma seperated target file: account 9876, finance 5432, premium 019...
- Tue May 02, 2006 1:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: string into date format
- Replies: 2
- Views: 1601
string into date format
i'm trying to convert string into date format. for example i get a date value as a string such as "01/03/2005" than converting into date format: 2005-03-01. i'm using this code: Oconv(Iconv("inputColumn", "D/E"), "D-YMD[4,2,2]") but executing it in the transfo...
- Wed Apr 12, 2006 7:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "has import error and ..." message for DATE field.
- Replies: 4
- Views: 5108
The field is a char field, so you need to declare it as such. ArndW, where does it say it is a char field? Would it help if I use dataset instead of sequential file? I'll try this tomorrow morning. Because, I read this document which says, using sequential file PX must perform import and export ope...
- Tue Apr 11, 2006 10:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "has import error and ..." message for DATE field.
- Replies: 4
- Views: 5108
"has import error and ..." message for DATE field.
Hi everyone, I have a sequential File at the source stage. If I click on the "View Data" button it does not return any rows and gives me below error message. However, when I change data types from "date" to "varchar" it returns all the rows. But I can't load this data i...
- Tue Apr 11, 2006 4:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to retrieve the source file name dynamically
- Replies: 7
- Views: 3424
Kenneth, Thank you very much. I appreciated it. One last question. I tried this code in server routine and it works very well but can I use server routine in a parallel job? If the answer is no then does this have to be implemented in a parallel routine? Any other way to do this? Also you said, &quo...
- Mon Apr 10, 2006 12:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to retrieve the source file name dynamically
- Replies: 7
- Views: 3424
- Sun Apr 09, 2006 11:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to retrieve the source file name dynamically
- Replies: 7
- Views: 3424
- Sun Apr 09, 2006 9:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to retrieve the source file name dynamically
- Replies: 7
- Views: 3424
how to retrieve the source file name dynamically
Hi, 1. I have an extract file which needs to be loaded into target database table. It's okay. But one of the requirements is that I have to get source file name and pass that name as a column value into the target db table. How can I retrieve the file name dynamically. Because this job will run ever...
- Sun Apr 09, 2006 6:58 am
- Forum: Site/Forum
- Topic: Do we need a General Forum?
- Replies: 13
- Views: 8501
- Sat Apr 08, 2006 8:07 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage logic vs SQL
- Replies: 14
- Views: 13362
- Sat Apr 08, 2006 9:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Two-step Look-up design
- Replies: 5
- Views: 2496
What is your source? Is it a database or a sequential source? Are your joins A->B->D 1:1? Is your source number of rows many times the size of the reference, equisized or much smaller? These fac ... 1- Source is sequential file 2- Look-ups are database tables 3- Joins are 1:1 4- Number of rows in s...
- Sat Apr 08, 2006 8:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash file look up not working
- Replies: 10
- Views: 4193
Re: Hash file look up not working
I really can't see any benefit of using hashed file look-up in this job. If it only contains a single constant value, can't you just get the number and hard-code it into the transformer stage? For example, @INROWNUM>1 and @INROWNUM<>1000
- Sat Apr 08, 2006 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Two-step Look-up design
- Replies: 5
- Views: 2496
Hi ArndW, Thank you for your reply. When you say; can do it in one job, do you mean: ..............................DataSet1 ....................................| ....................................| ....................................| Source..................Transformer..................Target .....
- Sat Apr 08, 2006 4:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Two-step Look-up design
- Replies: 5
- Views: 2496
Two-step Look-up design
I apologize if this is not the correct forum for this conceptual design question. I have to design a job in PX which has the two-step look-up requirement. In my design, I have to match the followings; ACCT_ID to BCCT_ID then BCCT_ID to DCCT_ID then write into Target table. My question is how to desi...
- Wed Mar 29, 2006 4:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to find the job design in the repository
- Replies: 2
- Views: 1251
how to find the job design in the repository
Hi,
I have a server job that using hashed file as a source stage. I would like to find out which job previously created that hashed file. Could you please provide some help?
We're using 7.1 server on IBM AIX 5.2 and client on windows XP.
I have a server job that using hashed file as a source stage. I would like to find out which job previously created that hashed file. Could you please provide some help?
We're using 7.1 server on IBM AIX 5.2 and client on windows XP.