DSXchange

Hi had a similar issue when trying to call the Microsoft Dynamics 365 API on DS 11.3 fp1 recently... Microsoft disabled support for TLS1, which is perfectly understandable! I did not need to apply a patch, we just upgraded the JDK and added the following line to the Hierarchical Stage properties: -D...

Are your decimal columns nullable in both of the Input links of your Join Stage ? If you have defined your decimal columns as non-nullable in DataStage, I think it will default the NULLs to 0 ? Also, you may prefer to use the NullToEmpty() function instead of the If IsNull() Then '' .. Else ... synt...

It is failing because on of the target columns is VARCHAR(20) . VARCHAR(20 byte) or VARCHAR(20 char) ? https://stackoverflow.com/questions/81448/difference-between-byte-and-char-in-column-datatypes What happens if alter your target column to VARCHAR(20 char) ? If you need to data type convert with ...

You indeed need an output link with the Lookup Stage.

But what I would do if I only cared about the Rejected data:

After the output link of the Lookup Stage, just add a Copy Stage and nothing else.
It should give you the result you're after.

Salut Franck, Where do you store the date you've retrieved from job 1 ? Try the following (there are other approaches, but I find this one to be the easiest to get right) - In job 1, write your date into a flat file, eg. param.txt Now your Job sequence should look like this: Job 1 ---> Execute Comma...

I haven't read between the lines, so this might not be what you have asked for, but anyway.. An option could be to have a "Wait for file Activity" Stage just before your 'End Loop' stage: - Filename: /ds_project/file_does_not_exist.txt - Wait for file to appear for 15 minutes (will never h...

Example of a Job sequence that allows us to load up-to 10 tables at the same time (250+ tables) http://i.imgur.com/UEp0Wc2.png First job just creates 10 flat files for looping through list of tables.. You don't need this. How about you try something like what is in the green square ? (Sequencer set ...

Personally, I was able to have an understanding of Conductor/Section leaders/Players, only after reading the last chapter of Ray Wurlod's white paper:

http://dsxchange.net/uploads/White_Pape ... aStage.pdf

In your target Oracle Stage output/columns tabs...
Is the 'Runtime column propagation' box checked ?

So you are trying to retrieve 'List data' from "Sharepoint Online ", is that correct ? I went through this exercise recently, it was a pain to get it working, mainly because of Microsoft's Authentication procedure which is not well documented. You need to read this: https://allthatjs.com/2...

According to almighty Google when you search for "Cannot load trust store" , it seems you have stuff missing in your odbc.ini file eg. from the first 2 search results: Add the following connection options to the SQL Server DSN in the odbc.ini file EncryptionMethod=1 TrustStore=xxxxx TrustS...

Or this
Could easily be done using the Pivot Stage.

And that just to say you don't need to ensure access to the shared library. At least that's how I'm reading it.? Yes, you're right. But anyway, the mystery remains for now: To access a Hadoop Distributed File System (HDFS) with the Big Data File stage , you must make the libhdfs.so [...] I understa...

thank you for your answers.

Franklin thanks for the reminder of stopping the Parallel job instead of the Job sequence.

There's an hardware change and I have been left with no choice but to stop DataStage if it is still running

Hi, Let's say that: - I stop a running but restartable Job Sequence (checkpoints enabled for each of its step) from the Director client. - Then shut down the Engine server. - Then shut down the Unix machine - After a few hours, I restart the Unix server and the Engine server .... Questions: 1) When ...