DSXchange

Hi, I have a before after job subroutine to capture records in a link , but I'm always getting result as -1 . Below is my routine $ INCLUDE DSINCLUDE JOBCONTROL.H RoutineName = "TestRout" StageName = Field (InputArg,",",1) LinkName = Field (InputArg, ",",2) vRowcount = ...

Hi All, Thanks everyone for the help. Timestamp datatype is working fine if I use ODBC stage, For DRS stage I need to use NVARCHAR(27) datatype and I need to use the TimestampToString function like below TimestampToString(CurrentTimestamp(),"%yyyy-%mm-%dd %hh:%nn:%ss") So when we are using...

Hi All, I'm trying to insert data in to SQL server 2008 table. The data type is Datetime2(7) and I tried all the combinations like using functions like below in transformer StringToTimestamp(TimestampToString(CurrentTimestamp(),"%yyyy-%mm-%dd %hh:%nn:%ss"):'.000000',"%yyyy-%mm-%dd %hh...

Hi, I have a server routine which writes the waraning messages and fatal error messages of a job to a txt file and also to the job log. The routine compiled with no errors. But when calling the routine from Routine activity from job sequence it is aborted by throwing below warning Attempting to Clea...

Hi All, I have Amount with Varchar(21) and it's getting data as 11302.06 and 0.00 in two records and I'm converting it to Decimal (21,5). I'm using a function StringToDecimal(SvValueAddedAmt,"trunc_zero") but I'm getting data as 0000000000011302.06000 and 0000000000000000.00000 Is there a ...

Hi, I have a job in which I have a date field which is varchar(10) and I'm getting date record in different formats like mm/dd/yyyy, m/d/yyyy, mm/d/yyyy and m/dd/yyyy example 10/10/2010, 1/1/2010, 11/1/2011 and 1/12/2011. I want to process record only with mm/dd/yyyy format i.e 10/10/2010. I used a ...

Hi, I have a job which has 4 stage variables svYear, svMonth, svDate and sv1 = svYear:'-':svMonth:'-':svDate svYear Varchar(4) svMonth varchar(2) svDate varchar(2) sv1 varchar(10) If the values for svYear is 2011, svMonth = 02 and svDate = 21 it is working fine and I'm getting output as 2011-02-21 b...

Hi, I have a Datastage job, which is insertind data in to a temp_arg table and it had two fields Strt_Date and End_Date with Date data type . In my job the input column data that I'm using to load the Strt_Date and End_Date fields is '2010-10-10 00:00:00.00' . In ORAOCI9 stage I defined the Strt_Dat...

Hi,

Can some one tell me how to delete the job that I cannot see any where in the rerpository from Designer Client.



Thanks,
Somaraju

Hi,

Can some one tell me how to delete the job that is in root directory



Thanks,
Somaraju

Hi Chulett

I don't see a job in project level or in any category from Designer client. Can you tell me what is this root level mean in Datastage designer. Where do I need to look for the root path.



Thanks,
Soma

Hi Ray,

I got the below message

LIST.ITEM DS_JOBS ''DimClt'' 15:49:32 10-28-10 PAGE 1

DimClt

001 NR0
005 14

Thanks,
Somaraju

Hi, I have a job Dimclt in one of the project Project1 and I'm trying to import the job in to Project2, it is saying that the job is already exists and I'm not able to find the job using advanced quick search. When I typed below command in Administrator command line SELECT NAME FMT '30L', CATEGORY F...

Hi, I have a job which is writting to a hash file. Selected the option Allow Stage write cache, I'm using an administrator default value 128 MB wite cache tunnable option. My question is, is there a way I can write a TCL command to increase to 256 or 512 MB for individual jobs instead of changing an...

Hi, I have a three server jobs , the three jobs are reading from a file and witting to a hashfile and there is a transformer stage between input file and hash file in all the three jobs. when I ran the three jobs in sequential order in job sequence each job is completed in 5 minutes and total time t...