DSXchange

Solution: Include the job design next time. There is really no good reason. Having the job design would allow you to visually verify and diagnosis problems with your programs if it fail. Like for this situation. Everyone seems to be bypassing your complaint that you do not have the source, and for ...

the dsx file you have does not contain the .o file needed for the execution of the job. Look into the file and you'll find a msg explaining the .o file is missing. That's why you MUST get back to the source project and do or ask for a "force compile" before export. Benouche, thank you for...

Hello, you have a problem with the export, the binary file being empty in your dsx file exported (you can check this in the dsx file itself with a text editor). Perform a 'Force compile' of the job in the source project and then the export/import procedure of the job. It will do it :wink: . Benouch...

T42 wrote:Go to the UNIX prompt, and verify that the file exists on that directory.

T42, I have checked, those library files exist, but with size = 0

Btw, if it doesn't exist, what should I do ? Why does the export can not capture all the elements it need ?

Eric wrote:Have you exported/imported the executable from/to a project on the same DataStage machine?

Eric, yes, on the same machine, different project

Benny, the error message is really quite clear - you have imported a job compiled elsewhere and when run it tells you that it has a bad magic number. Can you recompile the job in the new project and then run it? ArndW, I only got the executable, but not the source, so I am unable to toe recompile t...

Test258_Prod_Num: Failed to load the library "V0S397_Test258_Prod_Num.o". Either the directory containing the library file is not on the library search path, or the library was compiled on a system that is incompatible with this system. Could not load "V0S397_Test258_Prod_Num": 0...

But logsum still have the problem that some log end with '...' if the statement is too long in director log. you may build a routine to get the starttime and endtime to get the details which can solve the '...' problem Santosh, if you use the command-line program dsjob you will see that it has optio...

That is a good way !!!

T42 wrote:Import as a single varchar record.

Filter/Transform based on the first set of characters.

Column Export/Transform to split up the columns in a specific format.

Play on.

Thanks for reading ! It is still a null handling question, my case as below. Input : FieldA, FieldB Output: FieldC In transformer stage, derivation within FieldC If IsNotNull(FieldA) Then FieldA Else FieldB As I know, there is handle_null() function within Modify stage. FieldC = handle_null(FieldA, ...

I found some information from "DataStageEE_Remote_DB2_Configuration.doc". The DB2/UDB Enterprise stage requires DB2 Enterprise Server Edition on UNIX with Data Partitioning Facility (DPF) option. (Before DB2 v8, this was also called "DB2 EEE".) Furthermore, the DB2 hardware/UNIX/...

I have difficulity in configuring DataStage to connect to remote DB2. In DataStage server, 1. I have created a database node and alias that map to remote database under the DB2 instance db2inst1, and the connection is ok. 2. run db2grant.sh, but the following message return. DB21034E The command was...

Why I use ftp stage? because as you know, we can not edit a Dataset data (only can be viewed), so I want to transfer the DS file to PC in ASCII Text format, that I can edit the data to fulfill my testing cases. And then ftp back to AIX DS file. sachinkc, both the permission and disk space are ok. ds...

I have built a parallel job that contain FTP Plug-in stage, when the record count is less than 1000, it works well. But when it become larger, the following fatal message occur. FTP_Plug_in_20,0: Failure during execution of operator logic FTP_Plug_in_20,0: Fatal Error: Fatal: function 'ftp_put' fail...

That 's a good idea, thanks a lot

ray.wurlod wrote:You're right, you can't. But, if you're in the routine activity that is the final piece of the sequence, the time "now" should be close enough.

Code: Select all

Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(), "MTS:")