DSXchange

use the universe stage if you want to do a range match .. hashfile does an exact match ..

i like datastage too.. i work in a company where consultans work on all tools with different clinets.. and i am quite satisfied with it. apart from it has a habbit of crashing.. well when i said stuck i did not mean it in a bad way.. i think i got the answer to it .i.e the maturity of the tool....ju...

use the odbc stage..

create a dummy seq file with a dummy column which reads data from a dummy file with any value just to create an input link to the odbc stage.

seq file ----> odbc

in the odbc stage , choose user defined sql and u r ready to rock and roll !

well most of us just use this tool as it was already at the client side. and we did not have much of a choice.. tomorrow it will be another tool if the client is different with different requirements. I just wanted to know why Datastage... there are many articles which compare ETL tools. why are the...

not alot of information to come to any conclusions... have tried running the multiload script manually ? mload < abc.mld ? Does it run ok ? It seems more like a network issue to me than an issue pertaining to ML. try running the job at a different time of the day. Teradata Certified Master V2R5

You DO need a ## when you refer to environment variables i.e. #$EnvVar#

have u set the variables in sequence so they point to the parameters in the job activity at the sequence level ?

generally when you need column definition of a file. you just import the table definition where its going to be loaded, because the columns definition in the file is the same as the table. NOW. i am trying to import the column definition of a text file say abc.txt so i can load that into a seq file ...

why do u want to pad it ? why dont u use the TRIM function or cast one of them into INT .. i think that should work ok..

FOR VOC ENTRY............

SETFILE

: PHYSICAL PATH INCLUDING FILE NAME
: VOC ENTRY NAME
Y
DONE


FOR RESIZING..........


RESIZE [DICT] [filename] [type] [modulo] [separation]
[ CONCURRENT | INPLACE | USING partition] [64BIT | 32BIT]

thanks chulett...... was missing the file name in the phycial path. its working now and giving me no warnings when creating a VOC entry.

Reading through the posts and trying to create indexes on a sample hash file. 1. when i set try to enter a VOC entry it gives me a warning. that the 'DICT file path ' physical path name' does not exist, though it does create a link after it 2. when i try to create index on a hash file by CREATE.INDE...

or u can use the Hash file calcultor which is provided with datastage to calculate modulus... its called HFC.exe... easy and always works great !

Teradata does have indixes. and by default if no index is define it does create a primary index on the first column of the database. it lets u define 4 kind of indixes. Primary index, Unique Primary index, Secondary index and Unique Secondary index. So yes it does allow UPI and it does help in impro...

Teradata does have indixes. and by default if no index is define it does create a primary index on the first column of the database. it lets u define 4 kind of indixes. Primary index, Unique Primary index, Secondary index and Unique Secondary index. So yes it does allow UPI and it does help in impro...

1. Teradata has its own way when it comes to backing up and archieving data. it uses 'journals' to do so. Depending on your needs you can select and define upon table creation. For examples you can make a table fallback which means for every copy that is present in the table teradata will create a c...