DSXchange

What is the DataStage String function equivalent to cut -c command we have in unix. my requirement is extracting chaacter from position 11 to 20 from a string of 25 characters. I have to do it thru DS only

I observed that all posts related to this issue has the similar solution which says that we have to read the output as varchar and use DecimalToString in Transformer.. But when we were faces with this issue, one of my peers suggested using C_format option in the column properties...and it worked..An...

This option was initially thought upon but then rejected. Any way to do it in the job itself?

I need to convert a Unix shell script into a DS PX job. The shell script is taking a fixed width file as input sorting it and then adding an extra flush record to the end of the sorted output file. The extra record is nothing but spaces in all fields. i.e suppose the width of the i/p file is 100 byt...

How do I left pad an input string with a specific character and get the desired output? For example, if the input is ABC I want to pad X to the left of ABC and get the output as XABC

abhilashnair wrote:I am planning to go for DS certification, I hear that IBM has come out with certification for v8.0 as well. So should I go for this one or the older one that is v7.5?

Any suggestions on this?

I am planning to get certified....Is it recommended that I go for this one or stick to v7.5?

I am planning to go for DS certification, I hear that IBM has come out with certification for v8.0 as well. So should I go for this one or the older one that is v7.5?

I meant to say that the v8 has a lot of bugs. To cite one example that I know of is that the Oracle Load does not work correctly..ie we cant load to an oracle table directly. We have to do an upsert always.
So I was asking whether there are other bugs too?

Thanks for the reply, Ray. I could not read it fully due to premium content. Anyways, I liked your humour 'This Week'..goes to show IBM's inconsistency. Also I came to know it has a lot of bugs. Is it true?

1) First things first...This may sound elementary but I need to know the exact name of DataStage v8. What I mean to ask here is just like v7 is called IBM WebSphere Enterprise Edition(formerly PX) - correct me if I am wrong here-, what is the corresponding term for v8. 2) Is v8 a scaled up version o...

What is the difference between importing table definitions using ODBC method and using Orchestrate method, is one of them accurate than the other one? Which of these is recommended when Database is Oracle 9i?

I think I was not very clear on what I told. I am getting the warning not only for varchar(50) field That was an example. I am getting the warning for all fields of Oracle table. If there are n fields I am getting n warnings. I just quoted one of them because all are similar. Also, I had suggested t...

We have a Oracle table which has varchar2 fields. They are defined in the following way: Field_Name varchar2(n char); here n is the length and we are specifying char inside the parantheses because we want more bytes per character to be assigned. That is a requirement Now in DataStage 8.0.1 we are us...

Sorry Ray...do not have access to premium content...
But I have guessed what you have wrote.
Some versions of ODBC are incompatible..So that makes sense