DSXchange

To explain this further, i tried with a string column with same condition: CISNO <> CISNO_DB2 and it worked. For that matter, a decimal column without an alias work as well: AVG <> AVG But it actually compares to the same column. That being said, i tried searching for the error that i am getting, bu...

I was able to create a job and do a comparison. I am using a paramterized filter stage to compare a decimal column. For eg, I used AVG from hive (which is decimal (30,11)) and AVG as AVG_DB2 from db2 table (which is also decimal (30,11)). My code in the filter stage was as follows: AVG <> AVG_DB2 Ho...

I have 40 tables in DB2 which have been migrated to Hive in same exact structure as DB2. I need to compare column by column the values of each DB2 table with each Hive table. The column names for all 40 tables is not the same. I have designed a parallel job which reads both tables, looks up on a key...

we have a mainframe file which we are trying to read using Complex Flat File Stage. The column has data type PIC X(1) which we are reading as char(1) and assigning to char (10). problem is it converts to value "26" when the value should be 30. The value displayed in mainframe is x'30' (whi...

Thanks it worked. However in order to get a "+" if I use the option packed=no(separate) and sign position=leading I get the value as "+00000000". is there anyway I can get the whole "+000.00000) within decimal?

I have a column of decimal (5,5). I want to put default value as "+000.00000". I tried with several options such in meta data such as setting precision=5 or using the option "Packed to no(separate)", setting sign position=leading, but all I am getting value as "+000000"...

I am trying to connect to a hive database on a edge node (residing on another linux server secured with Keberos protocol). Following is my dsn connection parameters in .odbc.ini file: [EDL_Hive] Driver=/opt/IBM/InformationServer11-3/Server/branded_odbc/lib/VMhive00.so Description=DataDirect Apache H...