DSXchange

Hi,

Basically what i did is i tried to convert the time stamp to 24hr format like '2011-02-21 15:24:46' and then used Iconv('2011-02-21','D-YMD[4,2,2]'):Iconv('15:24:46':'MTS') for comparison

Please let me know if i am doing anything wrong.

Thanks in advance

Ravi.K wrote:Use Iconv function for both Source and Reference data then compare both values.

I have used Iconv function but still not able to satisfy the condition.

Hi, I have a requirement where i need to compare the time stamp from source and Reference records and if the time stamp from the source is greater than Reference record, i need to pass the data.i am getting the time stamp from source and reference as '2011-07-21 03:24:46.000000 AM'. When i gave the ...

Hi , I have a requirement where i need to delete all the hash files in that current directory where we usually store all the hash files in a particular directory after all the jobs are executed.So is there any way that i can use a routine or a command to delete the hash files.I used del *.* and then...

Thanks every one .As of now its working fine with this KeyMgtGetNextValueConcurrent()

Hi,

Yes,The two jobs are loading the same table at same time. So can you tell me how should i change the routine . should i change from "abc" to some other value?

Thanks in advance

Hi All, I am using one of the Datastage functions which is KeyMgtGetNextValue("abc") where abc is the table name in two jobs . when i run the 1st job its working fine , and then if i run the 2nd job , i am getting an error saying that 'unique constraint violated'. So can we use KeyMgtGetNe...

Hi All, I created a small sequence which includes two jobs and depending on the status of 1st job i need to load the data from the 2nd job. Everything is fine but the problem is when i run the sequence its working fine . so if the 1st job aborts , i need to run the load the data from the 2nd job whi...

Hi ,

I have initialized it and its working fine .

Thanks again

Hi craig ,

can you please elaborate to me as to how to initialize it. So do i need to intialize variable "abc" but how should i initailize it?

Any help is really appreciated

Thanks in advance

Hi , I created a small routine to convert string values to decimal $INCLUDE DSINCLUDE JOBCONTROL.H vLen=len(Arg1) For Arg2 = vLen To 1 Step -1 If Arg1[Arg2,1]="" or Arg1[Arg2,1]=" " then end else abc=Seq(Arg1[Arg2,1]):abc end Next Arg2 Ans=abc and when i try to run the job i am g...

Thanks for your reply..

Is there any "IN" operator that Datastage supports in order use for the above solution. If not , is there any other functions in Datastage in order to build the above solution

Hi , Is there any way can we pass multiples values in Job parameter . for ex: jprnum="1","4","sa" and use that job parameter to check the input to see if any of the values exists which is input=jprnum and if exists insert , if not reject the record which is input<>jprnu...

Hi ray, Is there any function to convert the hexadecimal to hexadecimal again until it is a pure number. for example Oconv("J","MX0C")=4A but i want the result as 441 which is that A shoukld be again converted to hexadecimal so if the input is like AJ then output should be 41441....