DSXchange

Hi,

The same logic applies even if Parent key is having referencial integrety on different table.

The point is -1 should be made available in the table before you load actual record.

Hi, I will make some assumptions before suggesting something. ----I assume that the 'Parent Key' is having referential integrity on the primary key of the same table. So, both fields reside in same table. ----"-1" is the place holder value that you are trying pass incase of NULL\Space. If ...

Hi all, Currently I have a requirement to work on both V8.1 and V8.5 DataStage jobs. We have 2 different servers; one for V8.1 and another for V8.5 and both are installed in windows environment. However V8.5 newly installed and we are in a process of installing the clients in multiple machines. 1. M...

I have not tried in command prompt. As I am new to the windows version I have limited knowledge on it. I used Execute command stage and also used Generic Stage seperatly. No. No luck with the copy of the job. I tried creating new sequence with Execute command and here in both these cases the Orchadm...

What I mean by not stopping is the sequence remains in Running status and never finishes. I tried to run orchadmin command using Generic Stage in another job and it executed. But the problem i am getting in the sequence job. The director log is having only 3 entires. First line -> Job starting info ...

Hi all, I built one sequence job having only Execute Command stage. I was using this stage to execute "orchadmin" command and also to execute "dsrecords" command (Manually changing the options). The sequence ran for both the cases successfuly for many times. However after 7-8 run...

hi,

Need to know your exact job design. Whats the source, stages that you have used, target details etc.

One Parameter value directly into another parameter is not possible. If you have to achieve this, use a sequence activity variable stage to conctinate as mentioned in the earlier post and pass that as to the job.

Is that answers your question?

try in transformer --> 'alphabets' :#parcode#

sorry.. i was slow...

Satish,

try -> "ABC" : CHAR(09) : "XYZ"

Yes. We can parameterize the query. No seperate syntax.
It worked for me for simple queries.
I am not sure about the complex/Huge queries.

One more thing is, if you are running this job at a time for different queries, make sure that you build this job with Multi Instance enabled.

I would assume you can find it in director log.

Ray is correct. I had this problem for my job. I tried compiling the job directly, and the popup has come showing the simillar error. But surprisingly the job compiled and ran fine. After 2 days when I open the job it was not reflecting the changes made to that job. I created the copy of the job - i...

bachi,

This warning will come only if we change the defualt partition method to any other method (other than entire) in transformer stage.
So you can ignore the warning as you have explicitly changed the partition for your requirement.