DSXchange

Is there a way to pass database name as a parameter in DataStage ? Basically, there can be many (hundreds) of databases on a single server, and I'm trying to find a way to dynamically switch the data source / target at run time. I don't think this can be accomplished within ODBC Connector stage beca...

Thank you guys. For the time being, I found a workaround and would like to share with everyone (not that it's a common problem!). I ended up using stage variable FIELD function and save the length of each input in stage variable as follow : StageVariable1 = Len(Field(Input.config," ",1,1))...

I have an input data in integer format as below :

150000
10000
1099

Is there a function in DataStage to convert the above integer into :

1500.00
100.00
10.99

I am thinking about converting to CHAR , SUBSTRING and concatenate the "." But it doesn't seem very efficient.

I have looked into using field function with no luck so far. But I am quite new to DataStage, so it's quite possible that I may be doing something wrong :) I am also trying to see if there is a locate function (similar to LOCATE function in DB2) to find the delimiter position in a string to start bu...

I have an input string chacters in the following format : ABCDEF ABCDEFGHIJ ABCDEFGHIJKL And I have a lookup table that stores rules on how to parse out the string character like (blank space is my delimiter) : XX XXXX XXXX XX I would like my output to be something like (based on the rule found abov...

I have been able to create a connection to SQL Server from Windows but not much luck on the Linux server. Does anyone know if SQL Server Enterprise Stage is available ? I was able to create an ODBC data source but wondering if there is a simpler way. Eventually, what I'm trying to accomplish is be a...

Oh, I will do that now. Thank you for the tip as well! :D

It works!

Thank you very much for the pointer. Under Sequential File Stage, I
found File Name Column under Options. When I add that column name to
the output, I now have the file name (and the path). All I need to do now
is parsing out the file name.

This is too cool~!

That is correct -

Would it mean that I have to know the file name ahead of time to be able
to pass it in at runtime ? I need to automate this since I may not always
know the file name ahead of time or want to look for file name to be
passed in as parameter manually. Sorry if I misunderstood your response.

What's the best approach to parse out the sequential file name to be used as a variable inside Transformer Stage ? For our project, file name is a unique ID that will be used within jobs to populate our target table. Am I correct in thinking that I may have to use Job Sequence to execute linux comma...

I am new to DataStage and would like to find out what other people are
using to populate some common dimensions like date or year dimension.

What are most common attributes and how to populate the table appropriately ?
Do you guys use stored procedure and database function to add dates ?

We just completed 8.1 DataStage installation on Windows OS. I need to create a connection to SQL Server 2008. But when I create a parallel job and pick SQL Server Enterprise, I do not know how to point to the SQL Server environment. Is there a step-by-step documentation that I can follow anywhere or...