DSXchange

Hi All, I am stuck in requirement where I need to pass DATE_FROM and DATE_TO in sequence job activities where DATE_FROM is first day of previous moth and DATE_TO is last day of previous month if I am running my sequence in current month. Can anyone help me with the date derivation logic. Regards Pra...

RIP Kim!

Hi all,

We got resolution of this issue. We have created Datastage object in salesforce.com and it will store the Jobstatrttime and objectid and objectname. This will be used for extracting delta from sf.com.

Many Thanks

Hi All,

Anyone can help me on above topic.

Hi, I am trying to extract the delta records from salesforce.com pack stage and I found the below post on this topic on dsxchange: http://www.dsxchange.com/viewtopic.php?p=441564 From the post it is clear for me that we need to add custom object called DataStage in salesforce.com with fields called ...

Upgrade to DataStage 11.5. The SalesForce.com pack is included for free.

Hi, You will have three options in stored procedure stage, source ,target and transform. If you don't have any input to stored procedure, then use it as a source and you will have option of return code and error code on the output link I believe , and based on this you can do the transformation. Ple...

If the column type is nullable =Yes then datastage will put null so I don't think there is an issue in comparing two input links.

Or you can enable the APT_DISABLE_COMBINATION and execute the job,you will come to know which operator is having issues.

Thanks
PRasoon

Hi,

Read it as Unicode character.

Hi, Below is the basic routine, it may help you. $INCLUDE DSINCLUDE JOBCONTROL.H JobName = FIELD(Arg1,"|",1) ****JobName = DSJ.ME hJob1 = DSAttachJob(JobName, DSJ.ERRNONE) jobStart = DSGetJobInfo (hJob1, DSJ.JOBSTARTTIMESTAMP) latestID = DSGetNewestLogId(hJob1,DSJ.LOGANY) DIM evtVector(lat...

Hi All,

I am able to resolve the issue. I was getting error because there were two columns with same name and while importing the metadata in job, one of the column was not importing.

I raised this concern to associated team and they renamed one of the column.

Ok I have removed row regenerator.

Now my design is :

Stored Procedure Stage -----> Peek Stage.

Still I am getting same error as I have mentioned before.

What could be the reason for this issue.

Thanks
Prasoon

Ok, In my case data is going out so Source Stored Procedure will work. Now i am struggling with my first issue,with error like "al: Wrong number or types of arguments in call to dbo.UP_IN_AMBIT_PRICE" Here we don't have any argument passing to stored procedure and yes we are getting a retu...

Hi,

I executed the PROC on sql server and its giving output:

USE[IMJID]
GO

DECLARE @return_value int

EXEC [odb].[UP_IN_AMBIT_PR]

SELECT 'Return Value' = @return_value

GO

In this case which stored procedure type will be appropriate (source/Transform).

Thanks
PRasoon