DSXchange

Hi Guys It's been a while. :D I have records going into a transformer and then split either of two ways, one to LN_BSNS and the other to LN_PERSONAL. More often than not, there are no records going down to LN_PERSONAL which in turn does a inner JOIN to a fairly large Dataset. My question is this - s...

you may want to do a search on this environment variable: APT_DECIMAL_INTERM_ROUND_MODE

APT_DECIMAL_INTERM_ROUND_MODE
Specifies the default rounding mode for any decimal intermediate
variables required in calculations. The default is round_inf.

I changed the code from function (removing code not impacting post): If Num(Trim(linkname.column_1,'"',"A")) = 1 Then Trim(linkname.column_1,'"',"A") : "000" Else something other code here : "000" To Trim(linkname.column_1,'"',"A") : &...

Hi guys I experienced a strange error today, but managed to fix it by excluding the piece of code generating the error. I am getting source data that I test whether it's a number using the Num function (removing code not impacting post): If Num(Trim(linkname.column_1,'"',"A")) = 1 The...

Hi Guys I'm trying to decide if we are overusing varchar data types when doing joins/lookups in Datastage. In 99% of situations we cast data to same varchar types and lengths before doing a join, merge, lookup etc. It may be we're not experienced in using decimals/integers etc, but my real question ...

recieved this code, hope it helps:

thanks Ray

Hi Guys Normally we would just run the before job subroutine "CLEAR.FILE HASHFILENAME" to clear a hash file in the current project. We have a scenario where we are reading and writing to the same hash file in the same job (aggregating), but need to clear the file before the job runs. The p...

turns out there was a syntax error or something that caused the error to appear!

Hi there Is there a known issue when using UNION ALL in the teradata API stage? We have a piece of code: SELECT BLAH, BLAH2 UNION ALL SELECT BLAH3, BLAH4 UNION ALL... (45 UNION ALL statements) that returns a fatal error "Unrecognized SQL statement". We've removed the UNION ALL statements (...

Do a left join and bring in the key columns from the RIGHT table/source. Set up a transformer or filter after the join and send data where the RIGHT table/source columns are NULL down the reject link. These will be the rows that did not match to the RIGHT table/source I think i have it right... or i...

the setting mentioned is:

APT_DECIMAL_INTERM_SCALE
Specifies the default scale value for any decimal intermediate
variables required in calculations. Default value is 10.
(page 6-14 of the parallel job advanced user guide)

Hi Guys I'm on the verge of finally cracking an XML to MQ problem. Now I need to call ont eh experts :D Steps followed: 1. Created job that creates XML. finished OK 2. Amended job to take XML and write out to MQ stage.. I have one column (the XML) coming from XMLOutput to MQ stage. The data type is ...

thanks for the responses - i'll feedback to the team.

Hi Is there a relationship between the number fo table definitions in the repository and the impact on performance of the jobs? I can think that the repository which stores everything will be impacted and that at a minimum job start-up time will be impacted, but will the runtime of a job be impacted...