DSXchange

Try to put the dsjob report command in a shell script and execute the shell from Datastage.

If your source date is in the format of yyyy/mm/dd then don't define your target datatype as date in DB2 stage. Just define it as Char(10) though it's date. DB2 stage will take care of everything...you don't need to iconv or oconv...

I found a way to browse the queue from command line...
It can be done using the queue browser called amqsbcg.

Hi I have designed a job to read message from Queue using MQ Stage and to write into Seqential file. Job design is fairly simple(MQ Stage to Seq File). Job runs fine meaning it did not throw any warnings or errors but it does not read any messages...I was told that there are messages in that queue.....

Use MC/A function with oconv.

Craig,

Can you please share top 3 reason why you don't want to do that ?

I can think of few like validating parameter files, hard coding lot of directories/variables and capturing the log...

Thanks

Hi

Do you know of any third party schedulers(like Autosys, Control M etc...) which is integrated with DataStage meaning that we can kick of the DataStage Jobs directly from Scheduler without having to write a shell or windows bat scripts.

Thanks

chmod rwx rwx rwx abc.sh where r means read(4), w means write(4) and x(1) means execute permissions.


If you enable the excute bit(x) then it will become abc.sh*

For example 744 should change ur script to executable

Check the NLS date time format of your database and convert it accordingly. Normally it would be yyyy-mm-dd hh24:mi:ss.
No microseconds like DB2.

Thanks

I learnt an easier way of doing this. Just need to change the data type of the DB2UDB stage to char from timestamp and pass the value as it is.
It takes care of everything. Don't need to do iconv or oconv...
This will work only if the dates and timestamps are in db2udb format.

Thanks

No. I don't...I only have two records in my source

Thanks

Hi One of my source column in my source file is in this format yyyy/mm/dd hh24:mi:ss.000000 and my target is in db2udb with a column of datatype timestamp. If I just pass on the column I get this error... Value treated as NULL Attempt to convert String value " " to Timestamp type unsuccess...

Thanks Ray...I got the same reply from IBM.

Thanks for the reply.

Actually the problem I think is we have not installed MQ yet on the server where DataStage is. Do we need to install MQ server on the same server as DataStage OR Is it enough if we just install the MQ client in DataStage server ?

Thanks

Hi We have just installed MQ Stage and am trying to access queue from this stage. I am getting the following error... ds_loadlibrary: error in dlopen and then this message... read_MQ..Sequential_File_1.IDENT1: C Stage PlugIn function "Get" required Is this security issue or the problem in ...