DSXchange

we tried that also, we asked our DBA to check the settings and he says settings are same.
is there any additional insert statement we have to give other than USING?

hi,i am using teradata enterprise stage to load the data from a dataset.i am using replace option ie, drop the table then create a new table and load the data.The same job working in development box, but it is giving warnings on the system test box.following is the error. APT_TeraWriteOperator:DB Ca...

yes i have given the same parameters in the sequence also ,
even though it is nor running ,but in some other jobs when i am extracting the records from the same table it is extracting when i am running in the sequence or the job

hi i am using the teradata Enterprise stage to load the data in the teradata tables using the option as replace.the problem i am facing is while running individual job it is running fine but when it is running through the sequence the job gets aborting getting the following errors.my source values a...

i am loading the data in to oracle using oracle stage. i am uisng the properties disable constraints and index rebuild. but i am getting the following warning. Tgt_Bada_Consistency_Res: When checking operator: There are no indexes on table 'BADA_OWNER.BADA_CONSISTENCY_RES' and an index option was in...

i am getting the correct values.
thanks for everybody's help.

i think it will work
thanks for your help

is there any function or code which will give (no of months/12) to a yyyy-mm-dd.
is there any logic how to convert or change.

actually the file which i am using is coming as a .txt file from mainframe.
from which i have to extarct the values and load it into secveral columns that's why i am using column import stage.
and after 173 bytes there is no char i mean it's a space values.
but i am taking only 173 bytes.

the values are like this
2002-07-07,2005-05-05(date) and 390,231(char)which is no of months.
my requirement is like this 2002-07-07-(390) and the output is again a date.

hi,
i am having a requirtement for which i needs to convert months into date.
in my source side hae 2 columns date and varchar which is number of months and in the target i am having a date for which the logic is (date-no of months).

can anybody tell me how to convert the no of months to a date.

no, total length for all columns is 1061 bur for particular this segment(CU) i am having only 173 bytes .

the format is binary and i am importing the data as char.

i have given the filed delimiter as none and record delimiter also as none.
is there any problem with that one.

hi, i am having a problem with column import stage when extracting the data from sequential file which is a binary and importing no of columns which are char.i am getting the following warnings . columnCU,0: Import consumed only 173bytes of the record's 1061 bytes (no further warnings will be genera...