DSXchange

Hi, My requirement is to get the Max(col1) and use this value to increment by one for each input row and create a load file, subsequently this load file used to load the table. when i use the sql using MAX on a column in ODBC stage it is giving error "Fatal error not a valid Identifier MAx(col1...

No Luck !!! Still the same answer - 08 , for the example which i provided.

Hello. You should define 4 stage variables as 1stQrt: If (month(indate)+3)>12 then (month(indate)+3)-12 else (month(indate)+3) 2ndQrt: If (1stQrt+3)>12 then (1stQrt+3)-12 else (1stQrt+3) 3rdQrt: If (2ndQrt+3)>12 then (2nd+3)-12 else (2nd+3) 4thQrt: If (3rdQrt+3)>12 then (3rdQrt+3)-12 else (3rdQrt+3)...

I am sorry, I did not explain properly,

You are right the next quarter should be calculated based on current month. But if the calculated Quarter is current month use the current month as current Quarter.

Hi, I have a requirement to calculate next quater month based on the provided month and using the derived quarter month value need to calcuate the next earliest quarter month. For example I have a date 2005-05-20 next 4 quarters based on this dates are 08, 11,02,05 months respectively, Then i need t...

Hi,

Need some information to get the 24 months back date from the current date. I need to use this date for filtering out the records which are older then 24 months.

any help is appreciated!

Thanks

Thanks Ray, I am not sure will it store as timestamp or Char filed if i concatenate "00:00:00.000" and move the filed to SqlServer. If it stored as Char - i hope we may not able to do data functions on this field. But I did defined the SqlServer column data type as Chat and selected Data e...

Hi Ray,
what would be the Data type in SQL server side.
But source is Date not Timestamp.

Thanks

I am loading data from DB2 to SQL Server, I defined the SQL Server column as Date type as DATE, but then i move data DB2 Date field to Sql Server Date fields it is aborting. I tried SQL Server column defining TimeStamp it worked with Current TimeStamp. So, my question is what is best SQL server data...

Can you post the code please The query given by kim will return all the Hash file names.Loop it and then use SELECT Count(*), '#HashName#' FROM #HashName#; and write it to a Sequential file. My approach at that time was different. any how if you want the code, tell me ur mail id. I will send u the ...

Can you post the code please

Thanks It worked!!!

Could you please guide little bit more
I created 2 stage variables and using the below logic, i am missing something !!!

Indrani, for the first one Try this routine $INCLUDE DSINCLUDE JOBCONTROL.H * ----------------------------------------------------------------------- JobStatus = '' * ----------------------------------------------------------------------- OldJobName = JobName RunHandle = DSAttachJob(OldJobName, DSJ....

Hi, I need some thoughts and logic on the follwoing requirement. I have a set of data by date , week, period and amount each weeks amount is added to next week till the end of the week of a particular month. My requirement is to write the amounts per each week by subtracting the amount from previous...