DSXchange

Hi - Currently we have process logic with set of parallel jobs and sequence which is batch scheduled. New business requirement is to have the batch jobs triggered as soon as the user updates happen from Front end (UI). I am thinking if we have the ISD job (always running job), UI can invoke the ISD ...

Hello Ernie The header i am getting is below , "submission" is the root element. <submission xmlns:ns1="http://www.xxxx.org/ns/2010/xxx/xxx" guid="" vendorid="19489"> Regarding format, my client is submitting xml files to external vendor and the tool which the...

Hi All I am working on generating XML Files and i have couple of issues. I am using XML Output stage to generate files. 1. The output XML file after Job finished, i don't see the below header, i checked for different options to generate this but i couldn't find any. Any way to generate below header ...

Hello, Can we run dsjob command from a java code ? I have a requirement , where user passes values to paramaters from web GUI and datastage job should pick them and produce xml file accordingly. I cannot use ISD because to produce xml, i have 2-3 pre jobs i need to run to actully run xml job in sequ...

Hello . I am trying to call store proc (oracle) which performs truncates based on input keys. One of the input key (p_measure) in store proc is declared as varchar. When passing the values to store proc in datastage, null value is getting passed for p_measure key. To debug, i am routing the values o...

Hello, We are using 8.7 Version, I am trying to insert null value in to a date field, in oracle,which was defined as nullable and default value as null in table. The expression i am using is : if Trim(lnk_tr.eff_dt) = "NULL" then SetNull() else StringtoDate(lnk_tr.eff_dt,"%yyyy-%mm-%d...

Hello, I am trying to create a routine, where i am trying to use parallel function such as stringtodate() , currentdate().... I tried to look at some header files in /opt/IBM/InformationServer/Server/PXEngine/include/apt_util But i didnt find any of conversion functions in these header files. Can an...

Thanks Ray

Use CAST(RT.ID AS VARCHAR(10)) in the SELECT statement. Yes, Thanks Ray. I totally forgot this CAST. I did tried this one and it ran fine. One question though. If the source integer column ID is 10 in length and iam doing IN as (RT.ID) IN (1093,1094,1095) where the data inside IN is 14, does it per...

Hello , I was tryng to do a sparse lookup, the column in table is decimal and the orchestarte column i am passing is varchar.The reason i am passing varchar is, i need to simulate (RT.ID) IN (1093,1094) in query as (RT.ID) IN (ORCHESTRATE.Input). From input i am getting 1093,1094 as varchar in singl...

I came across : "If the job includes a source queue that does not use a work queue, you must set the Message read mode property in the connector to Keep. Then you must grant the get and browse authorizations for the source queue. In this case, the connector reads the messages in browse mode, an...

Hi All, I am trying to achieve: When the records from MQ are successfully loaded to target DB then messages should be deleted from queue. But when message is failed loading in to target DB message should not be removed from MQ. ---- My understanding on using Work Queue(with in MQ connector) in DTS p...

yes it was EOW and when loaded data in to target it has no effect.

Hi All,

I am trying to read records from a queue and load in database.

All records are coming fine but, MQ connector is populating one extra record/partition.

Like,

Peek_11,1: --.

Is there any property to set to remove "--" or is it some kind of EOW marker ?

Thank you.

I think the reference data is loaded in to memory as lookup stage, but based on purpose codes. The amount of data gets loaded in to memory depends on purpose code settings.