DSXchange

Hi All,

Does anyone happen to have a link to the content presented in this webinar?

I missed it. My mind was in another time zone unfortunately.


Thanks

Thanks. I will check it out.

I initially started with a few DSJob scenarios, but not having explored the full capabilities of MWB, I thought I would go after that first. Ultimately, I want to send out an email each morning that summarizes what tables were loaded the prior night and the associated insert, update counts. DSJob wi...

Hi All, I created an MWB query(asset type = job) to extract job row counts(shows counts for all my previous job runs, as well as my latest run). I really only want counts for my last run(current date). In the query criteria, I have selected job start date and want it to be equal to the current date....

Thanks for the info. I'll try it out.

The after sql statement inserts a trigger record in a status table. The appearance of this record indicates to a legacy load process that this table has been succesfully loaded by Infosphere, allowing the legacy process to continue on.

Thanks

:D

Workaround.

Removed the 'after sql statement' from Oracle connector stage. Created new job that calls a stored proc(which performs the after sql statement). This new job is setup in my sequencer as a successor job to my Insert job. And will only run if my Insert job was successful.

Hello my friends, I have a job that uses an Oracle connector stage to insert records into a table. I also have an 'after sql statement' defined in the connector stage. I noticed that when my Insert statement fails(and job aborts), the 'after sql statement' still executes. Don't see much in the docum...

Thanks for the Info. I will give the xml a go.

Hi Everyone, Some background: HL7 - Health Level 7 data format: Version 2 HL7 - proprietary format. Version 3 HL7 - xml format. I read a couple of posts on this topic from several years ago, but not sure how much has changed since then(if anything). I believe datastage TX can consume this format, ho...

Try write mode = 'Bulk Load'

thx

Hello All, I read a few posts that pertain to this, however I am interested in something slightly different. We receive several hundred database structure changes once a year as part of a vendor software upgrade. Some of these changes will directly impact our existing Infosphere jobs. I would like t...

Anyone know of a DSX cutter compatible with 8.5 exports?

I guess I could write one.

Thanks

That would work. Something similar I was thinking of is to pass a value in the replace parm(something like 'REMOVE') to the routine and then alter the routine code to change the replace value to null if the replace input parm has a value of 'REMOVE'. I think the routine will do the right thing if th...

Hello Everyone, I used the pxEreplace routine code(posted here by DSGuru2b - good code - thx). Works great. I thought I could use this code to remove a string also(by passing nothing as my replacement parm(tick tick - ''). It appears to work when I test the code in a windows c++ ide, but when I run ...