DSXchange

Hi, I am using Parallel Job and I want to insert timestamp value into Sybase database. My timestamp value should be currentdatetime() - 5 (5 hours). Since we are loading the value from our dev server which is using GMT But our other server which is using EST is picking up these records based on Upda...

Hi Arndw,

Thanks once again for the immediate response.
Now i can think of writing some scripts for the above functionality.

Thanks.
Regards,
Krish

Hi ArndW,

Thanks a lot for an immediate response.
I have a similar doubt regarding Mqueue. Can i do the similar functionality (Mqueue the file in compressed format). I am very new to the mqueue stuffs.
Thanks.

Best Regards,
Krish

Hi, Since some of our files are very big, I want to ftp the same in Zipped format using datastage. Can anyone throw me some light on how to go about it. I have ftp'ed a sequential flat file successfully using sequential file stage and ftp stage but not sure how to do that for a compressed file. Plea...

Hi Sai,

Thanks a lot for your immediate reply.
I will post it in correct forum hereafter.

Thanks again.

Best Regards,
gopal

Hi, I am using Parameter file to get parameters for my jobs in the sequence. In that I am using from date and to date parameters. I am generating the dates using Unix scripts. Now i want to elliminate that and directly assign sysdate to the date parameters in datastage without using the file. Throw ...

Hi Ray,

Thanks a lot for your valuable input. It works fine.

Thanks everyone for your support.

cheers,
gops

Hi Andw and Sai, Thanks a lot for your immediate feedback. I have incorporated the same using single column. But my requirement is i need to change few column values based on some condition which is very difficult to implement if i use a single column. Is there any technique by which i can handle th...

Hi, I am storing the source data in a sequential file without column headers. I am having different records like F1,F2 etc., I am having different number columns for each. For example F1 has 100 columns, F2 as 200 etc., When i specify less columns in the file definition , I can able to view less rec...

Hi Ray, I can use decimal places but I am not sure about the actual data that is coming in. Some may require more decimal places and some may require less. If it requires less spaces and when we assign 5 decimal places then it is adding that many zeroes after the required number. How can i control t...

Hi , If the data is stored in Exponential format say 4e-05 then how can i convert the same in proper format. does anybody handled such things. Initially I am storing it in dataset and then i read from dataset to load the same in Sequential file. I want to incorporate such logic in the second transfo...

Hi Ray, First of all Sorry for the delayed response. In one such mapping i was able to see 6 or 7 decimal places without any exponential problem. The source data is float and i changed to double (at sybase source level) and subsequent columns to varchar2 and in that i applied dfloattostringnoexp opt...

Hi Ray, I can able to see similar kind of data (i mean data with similar precision) in correct format except one where the input is like 0.0000 or 4.0000. I mean if the source data is like 3.0456 and all i can able to see as it is. I am storning the data as varchar2 only and ofcourse there is no pre...

Hi, I am not able to load the data in the target (dataset) in the same format as my source (sybase). I am using PX and in server jobs i can able to do that without applying any rules. The data which is available like 0.00003 or similar kind of such stuffs are displayed in expontial form in the targe...

Thanks Arndw for your valuable inputs. I think I can go from here onwards. Thanks a lot onceagain.

cheers,
gopskrish