DSXchange

Hi All, I know there are multiple ways to call a Shell Script in Datastage such as, 1. Execute command activity 2. Before/After job Subroutine 3. Transformer stage ? etc... I am trying to figure out the best way in terms of overall performance. Can anyone shed some light on what is the ideal way to ...

Thanks for your reply Ray.

There is no specific format requirement, all we need to do is convert the current date to a valid GMT Timestamp format.

Pls let me know if TimestampOffsetByComponents() function will work in this case.

Thanks
Freddie

Hi All,

Are there any ways to convert a current timestamp to GMT format using Datastage prior to loading to Oracle Exadata ? I couldn't find any specific functions in transformer nor arrive at a solution.

Any help/thoughts are appreciated.



Thanks
Freddie

Thanks for your reply Ray. One of the reason why it is BLOB is to bring in more flexibility in terms of what we would store in the future.

Are there any other ways in which we can perform a Bulk Load operation against Oracle Exadata table with BLOB fields in it.

Pls help.

Thanks

Hi All - I am facing issue in one Datastage job that reads the data ( Has fields with JSON data, defined as BLOB datatype in the Oracle table) and performs BULK load to the Oracle table. Note that this table doesnt have any constraints defined, so ideally its supposed to perform the load run faster....

Hi All,

I am doing a PoC to check whether its possible to Read/Write to Marklogic NoSQL Database using Datastage. It looks like its possible using REST API.

Can anyone help me understand how to invoke Rest API using Datastage ?
Datastage version : 9.1.3

Thanks
Freddie

Hi All,

Do anybody in this forum tried connecting to Marklogic NoSQL DB (Document based) using IIS Datastage ? Pls let me know whether its possible using any stages in Datastage.

Thanks
Freddie

Hi All, Good evening. Is there a function ( or set of functions) that can convert a timestamp value (which is in EST) to GMT timestamp value ? I am trying to convert a timestamp field coming from an input file & it goes to a output file. ( so running a Currentimestamp-current timezone in DB2(as ...

Hi All, I searched the forum to find any posts related to the IIS Datastage connectivity with MEMSQL Database that is currently hot in the market. Can anybody shed some light on how do we establish connectivity between datastage & Memsql DB if you tried it in your projects. Any thoughts would be...

Thanks for your quick response Andy :) I will try this out & let you know. Meanwhile, is there a way I can invoke the DB2 load utility in the DB2 connector z/os without initiating the FTP transmission ( Transfer Type option in DB2 connector stage) to use a file present in the Mainframe system fo...

Hi All, I have a requirement in my project to do a Bulk Load/Replace into the Mainframe DB2 tables using DataStage. The data files sit in the Mainframe system. I am trying to invoke the DB2 connector stage (alone) through a DataStage job that will in-turn invoke the DB2 utility to trigger the Load/R...

Sorry for being unclear.

I need to delete all the existing records & load the new records into the table.
Hope it is clear now.

Thanks
Freddie

Hi All, I have a requirement in my project to refresh the data in 10 DB2 tables ( volume is around 80 million) and load the fresh records into it. I am planning to go with the following options in the DB2 connector stage, Write Mode : BulkLoad Table Action : Replace Record Count : 2000 Array Size : ...

Hi All,

Can someone pls help me with some thoughts around this. Pls let me know if you have any questions.

Thanks
Freddie

Hi All, I am planning to use MQ Stage to read real time data from MF Message Queues. There are 2 data centers where the records would be transmitted. i.e. records from Mainframe Data Center A will be transmitted to Midrange server A as well as the Datacenter B (eventually to Midrange server B also )...