DSXchange

What is the data type of INSERT_UPDATE. If it is Strings then shouldn't U be in single quotes?

Main.INSERT_UPDATE = 'U'

Hi, I have never debugged this big error. So, I don't know if I can be wrong. But, looking at the error below. I think that you might be missing right parenthesis some where in the code. And there are many warnings for type conversion. You can read it few lines above where it says "*** Internal...

Thanks guys for all your input.

No.
It doesn't matter in my current project.

I was just curious.
I also thought that even if there was any such number than it would be too high.
And practically it would be impossible to reach that number.

Thanks for the reply.

One of my colleague has concurrently ran 200 jobs at the same time.
So, what is the maximum number of jobs ran by you guys at a given time.

Hi, I was having chat with my manager yesterday and he was asking me that what is the maximum number of jobs that we can run in DataStage at a given time. Because some tools like Informatica has limit. I have never ran more than 3 to 4 jobs at a given time. So, I am curious to know what would be the...

I also had the same problem. But, there was no answer to that. So, I came up with a solution. I am using a Surrogate Key Generator which is using a State File. And run the Surrogate Key Generator on Single Node. Otherwise, you will skip few numbers. Re-Initializing the State File: I built a job whic...

Extract Date -----> Read file -------> Extract Query Above the structure of the Job Sequence. First you Extract the Date and write on to a file. In the next stage you read the file using cat command in Execute command(ExecCommand). And in the Extract Job write the below code in Value Expression in J...

Why don't you try to use Stored Procedure Stage in the pallete?

If you are sure that it is space then you can use Convert function in transformer to convert space to nothing. I don't remember the syntax. But it is somewhat like below: Convert(Old String, New String, Column Name) The above function can be wrong. But, I am sure there is Convert function in transfo...

It is not allowing me to delete the job.()

So, I think the only option left is to do the recovery procedure by running the SyncProject Script.

Craig, I am also thinking of involving IBM, but before that I want to discuss this with my senior DataStage Developer. I did some research and I found on IBM's website saying that the project might be corrupted. As I can see the Job present in Director but it is missing in Designer. http://www-01.ib...

Hi, I imported a DataStage job from dev to QA. I cannot see these job in repository. But, when I do following command in unix, it shows me the job under that project $ ./dsjob -ljobs PROJECT_NAME And when I try to import the same job again in QA, it gives me below error. The Job 'X' cannot be found ...

You can use field or Index function in Transformer.

What will be the output if the bridge_key has more than 3 values. For example, it has 5 8's. Then what will be the output.

And in you example when bridge_key changes from 4 to 5 shouldn't it be 3 instead of 1.