DSXchange

Hi Ray, I tried to compute the difference by specifying the difference as Datatype Numeric.i tried with all the datatypes but i am unable to compile the job. Thanks The difference can only be seconds. This will be a numeric data type of some kind, which can implicitly be converted to string (VarChar...

hello i want to find out the difference between two time stamps a:2010-01-04 14:10:13 b:2010-01-04 16:22:44 how can i obtain the difference between these 2 time stamps (b-a) in datastage.what would be the resulting datatype. because i need to convert the difference between the timestamps to varchar ...

can any one help me on this

Regards

Hello I have an issue while processing data from a file. Iam using seq file stage as source and i need to produce fixed width file so i am using seq file stage as target too.The file is fixed width (310 byte size) and i have file layout which specifies each and every field length. While i was trying...

Hi,

I am trying to find out total number of hours including minutes between two given dates(parallel job).

eg:
dt1:2009-12-23 21:00:00
dt2:2009-12-22 12:30:00
output: 15.30

Please help me out.

Thanks in advance.

Hi all, Can we enable/ diable a datstage webservice through command line? if so.. what is the command? in detail: I created a webservice from IS console, attached it to datstage job, deployed it and is working fine. Whenever i need to stop the services, ( for some maintenance issues) i'll just go to...

Thanks chullet for your reply

Kindly suggest the command to get the count for the Hased file after launching dssh.

Hi all,

Could anyone please let me know the Unix command to take the count for the Hashed file .

thnaks thanush

thanks ray,

Wondering how to make the second job run because if the first job is succes (lookup success) means there is a matching record exists and if matching record exists i dont want to go to second job

Hello we have 2 jobs and We have a requirement where in the job 1 we need to read the first record of a File and based on certain Key fileds i need to do a look up with Oracle table . if the key values exist in the oracle table then i need to abort the job and then as part of the job2 i can load the...

Thanks again all for your suggestions. I've investigated the names and found the most common patterns and added them to overrides, thus solving the problem. Thre are too many names to classify nd for sure we know that we will get new names , so I separated the most common patterns and added them as ...

Thanks a lot julio . It's working fine now..