DSXchange

I asked a question about setting defaults when joining two tables (HASH and DB2) and some codes aren't found. I coded the transform as this and keep getting an error. Two questions: Can I set two variables in the Then and else statements Can I remove the else and end and the code will pass through t...

I created an exception Hash file. Loc_cd Strt_tm End_tm I combined two tables, DB2 and hash file using a Loc_cd. During the join, it is possible that some codes on the DB2 table will not match the hash table. If there is no match I would like to pass a default strt_tm and End_tm that isn't in the ha...

Is it possible to code the SELECT statement in the code routine? The help documentation is very limited in this area.

Thanks

Thanks, it worked

I want to use the internal DS functions "Convertweek" and "Week.tag" in a built-in function. I get the following error messages

Array 'ConvertWeek' never dimensioned.
Array 'WEEK.TAG' never dimensioned.

Do I need to declare these internal commands somewhere.

Thanks

Is there a function or method to determine Daylight versus Standard time? I know that the first Sunday of April and last Sunday of October is DST but I can't find a function to determine this. Has anyone developed some built-in functions? As well, is there a function to convert EST to GMT? I can see...