DSXchange

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...

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...

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...

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...

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...

Kenneth,

In your job control (Batch, Sequencer, or custom job control)

1- "ls" command to get a file listing,
2- capture the screen output
3- parse it for the name.

Is there an example code you can provide? It will be my starting point.

kcbland wrote:Use any method you know to look at a directory and fetch the file name.

What about you kcbland? Do you any method? I wouldn't have asked if I knew any method to achieve this.

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...

We should have a forum where we can discuss conceptual design issues. Having said that, I think creating a General Forum is a great idea.

ray.wurlod wrote:DataStage is not a scheduler. It happens to contain a GUI so that you can use cron or at but it is not a scheduler.

Hi Ray,

When do we use Scheduling tool in DataStage Director then? What is it used for?

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...

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

Hi ArndW, Thank you for your reply. When you say; can do it in one job, do you mean: ..............................DataSet1 ....................................| ....................................| ....................................| Source..................Transformer..................Target .....

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...

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.