DSXchange

Hi , I have one requirement where I need to convert string to decimal tried different ways by searching in the forum but nothing worked out. Here is the example From Source I am getting Varchar(10) and target datatype is decimal(8,2) Source: +001000.22 Expected :- +001000.22 If the source is -001000...

Hi , I have around 20 jobs and I need to fetch the link info , start time and end time of jobs into the database. I have search lot on forum about implementing through 1. Job contol 2. C routine 3. dsjob -linkinfo 4.DSGetLinkInfo function I am new to DS parallel , Want to know which is the best opti...

ray.wurlod wrote:Do you want this solved as a DataStage task or as a "batch code" task?

If the latter, why did you post in a DataStage forum? ...

I just thought of Batch code , IF Datastage tool itself can help me to resolve this then it would be good...

Hi , I have requirement that I need to concate 3 files in the job. I have written a copy command in after job routine to do the below task. copy header.txt+detail.txt+trailer.txt Newfile.txt this works out sucessfully . But I have other requirement when the user sends the empty file and I need t gen...

hi,

Can any one guide me what does below logic means it was present in one of the job ,

The logic is in transformer constriant specially what does =1 means here

(DayssinceFromDate(EndDatetime, CurrentTime())<765 and Description<>' ')=1

Please let me know your comments on this.

Thanks

Hi , I am new to stored procedure stage could anyone guide me how to resolve the below scenario. I have a stored procedure ABCDE which takes two parameter its db2 sp. I just need to pass the parameter to this Stored procedure and inturn stored procedure reads those parameter and insert the records i...

Sainath.Srinivasan wrote:A simple fprintf will do the task.

You can use an exit to abort. ...

But I want log a message in the directory, what is the reason of abort can you please help me out how can i do this.

A simple fprintf will do the task. You can use an exit to abort. ... Thanks Sainath... I have attached my code below, actually my requiremnt is that i need to abort the job if certain condition does not match $DSHOME/include/dsapi.h #include DSINCLUDE JOBCONTROL.H #include DSINCLUDE DSD_CONST.H #in...

Hi,

Could anyone guide me how can i implement Utilityabortlog() fuctionality of server to parallel routine C code.

What all the declaration is required.

Please help me out on this if anyone has done on this.

Thanks

Hi ,

Can anyone please let me what all joins possible in lookup stage and Merge stage

As we have inner,left, right and outer joins in JOIN stage , i wanted to know what all joins can be done in merge and lookup stage

DS_SUPPORT wrote:What do you mean by secure? You don't want some jobs to be accessed by all or some other things?

I mean how security is handled in datastage jobs?

chulett wrote:You'd have to give us a much better idea what 'the security is taken care of' means first. Be precise. ...

Sorry,

i mean how do we say our datastage jobs are secure?

Do we do any security handling in the jobs?

Hi

i have basic question can anyone guide me

How do we ensure that the security is taken care to our datastage jobs?

Should we do some validation to ensure security is followed.

Hi,

Can anyone help me out with any scenario where we use user defined stage?

Please correct if my understanding is wrong user defined stage it something like we can create our own stage like sort, aggregator ?

Please let me know an example if any one has worked on user defined stages..

rmeenakumari822 wrote:Hi,

iam new to Datastage...

How to import Excel file to Datastage?

what r the steps to follow....

Thanks

you can do it as saving the excel file as .csv file and use a sequential file by reading from .csv file