DSXchange

Good Morning, I have scenario where I have to check the field value with the number of records getting loaded into the table. I am getting a file with header and trailer. From the trailer I need to take a field value( column value) and do a check with the number of records getting loaded into the ta...

Hi DSguru2B, I thought of doing the same but beside this column I have few more columns which are date fields. For each column I will have 3 stage variable of minimum. In next job I have 5 date columns so 15 stage variables right. So I like to get it done simply instead of all these. If nothing is g...

Hi Ray, I am getting excels file where I am converting them to csv file. While reading the file through datastage I got some import warnings for few columns. So for those columns I changed datatypes to "VARCHAR" and this date field is one. The column about what we discussed was exactly imp...

Hi DSguru2B, The expression worked for few reocrds and I am still getting '0' in the column for few records as input date format is changing. I tried using DateToString to put them in same format but still I am getting the value '0' for the expression in the column. EX:12/12/2006 1/1/2007 11/12/2005...

Hi All, I need to do a look up on date columns. The input stream date is in the format of MM/DD/YYYY(ex:11/01/2006,11/12/2006) and look up stream date is in the format of MM/DD/YYYY(ex:11/1/2006,11/12/2006). I am trying to convert them into internal format and do look up. I am using "DateFromJu...

Hi Keshav, For 3 records I can do this but I also need to generate 60 records based on the value of the a particular column mean if else condition,the value of the column will vary. From 1 to10. EX: If Column value=1 then 1*6=6 records , Else IF Column value is 2 then 2*6=12 and so on. I have 5 case...

Hi Ray, I designed the same job in server and checked. The job runs fine but when I see the output of the file on unix, data sorted is in improper. Example : Input record: COL1,COL2,COL3 101,runa,07/04/1981 Required output: COL1,COL2,COL3 101,runa,07/04/1981 101,runa,07/04/1981 101,runa,07/04/1981 T...

Hi, The input file as 10 columns and I am applying the same expression for respective columns. It is an example to show what exactly I am doing. The job has a sequential file as input and transfomer with expressions and output is a sequential file. I am not able to figure it out where exactly I am d...

Hi All, I have a requirement where I need to create three records for each record of the file. For each column I am assigning an expression in following way. For example: DSLink11.col1:Char(10):DSLink11.col1:Char(10):DSLink11.col1 to col1 column The job runs fine but in columns I am seeing '0' inste...

Hi Koti,
The error shows that there is no such file or directoty. Check whether you have the right path and right file name. And post your routine.

Hi Craig,
Got it. I saw it has server job and asked him/her to move the post to server forum.

chulett wrote:Sequence jobs are agnostic and apply to both products, so are perfectly fine being posted about here.

Hi asitagrawal Ray is talking about external sort utility and about the sort command in MKS Toolkit (a UNIX-on-Windows utility). I cannot read ur reply as it is marked as 'Premium Content'. For tagnihotri , I never heard of I/O max buffer in server job for a sort stage are you talking about parallel...

And if this is a server job move this post to server forum.

Hi,
Please do a search in the forum on the error you are getting. This is discussed here many times.For quick view
viewtopic.php?t=87807

Hi,
Please do a search in the forum on the error you are getting. This is discussed here many times.For quick view
viewtopic.php?t=87807

Hi, This error is because of the size. If this is a hash file then you need to check with the size of the hash file.Probably it is exceeding 2GB. You can get the size of hash file in DS admin/project by executing "Analyze.file hashfilename" in command execute. And do a search in the forum,...