DSXchange

Can Information Analyzer associate the Table definition in DataStage project with the sequential file on the node? The IBM person told me is that I need to create ini file with metadata, but I do have it in DataStage already. Also IBM person told me that for every sequential file I need to profile, ...

Ultramundane. I work at this place only a few month. I do not know how and why the original platform was chosen (many years ago). I think it was more of the skill set decision. This place does not have UNIX sysadmins. Now the whole Data Centre operations are going to be outsourced and there are fund...

Our company is planning to move DataStage installation from Windows platform. As a target platform AIX and Linux are been discussed. Apparently Linux is cheaper and if we are not missing much comparing with AIX, then Linux it will be. I am trying to make a case for AIX, but I do not know the facts. ...

You are correct. It did not work without char(254), but using char(254) did not make it right. Char(254) has a special meaning for universe shell and definitely does not work the way that you intended. Because you are on UNIX, try to use char(10) instead. It is just a guess. I am not able to test it.

It seems to me that char(254) breaks the command line into several lines and the second line of SQL already executes not under UNIX shell but in Universe. That gives those errors.
Try to write without char(254).
I do not have Oracle and Unix now to prove this.

Thanks. That helped. Completely forgot about those settings.

Lately the Annotation icons in my designer client appear grayed out. Now I am not able to add Annotations or Description Annotation stage to job design even though I can see them in my General group. It was working before. It is only a problem with my client. Other people clients are OK. I was tryin...

Rajasekhar
If that is as simple as you described, then a single stage variable will do.
Name is batchNum
Initial value will be 0
Derivation is
If MOD(@INROWNUM, 10) = 1 Then batchNum = batchNum + 1 Else batchNum

I do not know what dblink is. But in a "normal" situation if the table in Oracle is partitioned and you can use Oracle Enterprise stage, then you can specify partitioning in this stage and stage will send as many sequel statements as there are partitions. It will correctly add partitioning...

There's no point telling you where the checkpoints themselves are stored. Manipulate them with the functions you see in the job control code generated by compiling the job sequence. I disagree with Craig, I find it quite readable. I realized that the checkpoints are controlled by the group of DS fu...

You said previously that the table is not indexed. Does it mean that to create you ranges you invoke table scan 4 times. I would consider it a waste. PX approach that Ray recommends should work much better. My experience tells me that it does not wait for the last record to start sorting. It sorts a...

Can you describe under what circumstances you would envision a job needing to be skipped? If it's not something checkpoints can achieve, it may just mean that you need to build a conditional branch into your job stream... Craig. It is not that I am not able to code it in Sequence (using Nested cond...

I would like know where the sequence checkpoints stored during the execution. And can I change their values from outside of the sequence. The requirement is to be able to skip the job if needed. Of course it can be coded into routine or job control that runs the job. But I realized that the checkpoi...

I will when I get a chance.
Unfortunately this server is in heavy use all day long and we do not have a luxury of stopping it at will. Especially for the problem that is inconvenient for dsadmins only.
For now we decided to file a ticket with IBM.

Yes.