DSXchange

When I execute the following from command prompt it's working..fine --------------dropindex.bat----------------- C:\PROGRA~1\NCR\TERADA~1\bin\BTEQ.exe < c:\DS7.5\DropIndex.txt -------------------- I tied the following it's giving error... ExecDOS : C:\PROGRA~1\NCR\TERADA~1\bin\BTEQ.exe < c:\DS7.5\Dr...

You can Use the following in transform derivation...


Sysdate:
Oconv(@DATE, "D-YMD[4,2,2]")

Sysdate-1
Oconv(@DATE-1, "D-YMD[4,2,2]")

--vans

Can someone please look at the following code and correct it..I wrote all differtent pieces..and need syntax to call ExecDOS routine.... my problem here is to drop indexes before loading data into a teradat table using Multiload Plugin.. --------Teradata Drop Index Macro----------- REPLACE MACRO si_...

I have table with Secondary indexes on severl columns in Teradata so when I try to load data using Multiload Plugin I am getting the following error... 09:04:39 UTY0805 RDBMS failure, 3547: MLoad target table may not contain unique secondary indexes. it means I can't load data with secondary indexes...

Hey Nivas,
it looks like problem with config file(.apt) file..why don't you create u'r own .apt file and check it out..

--Vans

Sample_Exists and Level_Type are same binary datatypes on teradata

I am trying in two different jobs......


Thanks,
Vans

Use FTP Stage to transfer the files from one server to another

You can schedule a job in Datastage director to run weekly...
--Vans

still has same problem..
I tried with Iconv(DSLink1.Level_type,"MX0C")
Source is Bit Type and Target is Binary Type(Teradata)
need conversion...

Any suggessions would be appreciate.

Thanks,
Vans

Hi, I am getting the following error message when I hardcode the value "1" in transform.. TD_Main_Test..TD_ProdMast_Main: Invalid SQL column type for column Sample_Exists in stage TD_Main_Test.TD_ProdMast_Main TD_Main_Test..TD_ProdMast_Main.trg: DSP.Open GCI $DSP.Open error -100. Thanks, V...

Level_type has defined as BYTE(1) in Teradata.. when I import metadata into Job Binay is SQL Type.. level_type input values are 1,0, source is SQL server with datatype Bit I got following error message ........ TD_Main_Test..TD_ProdMast_Main: Unable to start MultiLoad process : MultiLoad failed: Che...

Hi, I am converting Bit into Binay datatype in Teradata(Byte) using server job.. I am getting the following error message... **** 09:49:03 UTY0805 RDBMS failure, 3857: Cannot use value (or macro parameter) to match 'Level_Type'. Can someone Please find me a solution... early reply would be appreciat...