DSXchange

check with data types, there may be white spaces in the key column values of either after records or before records.

try this : 1. Telnet to the DS server machine and cd to $DSHOME directory as root or dsadm account; (where $DSHOME is the DSEngine directory) 2. Run ". ./dsenv"; 3. Run "bin/uvsh" to enter DS Command Prompt; 4. Enter "LOGTO UV" to log into UV account. (*may not need to ...

how can we calculate difference between two timestamp in a routine.

What is the best way to call a perl script?

i am using a routine, in which i am using ODBC to connect oracle.
my routine is doing the correct thing but it is throwing an error as below

6066:
[DataDirect][ODBC 20101 driver]1514[DataDirect][ODBC 20101 driver]6060

Help please.

i do not find the "Extended" column property

i am using to read from a seuential file, and after transform insert into teradata table

i have a timestamp column in a sequencial file with a sample value as "2006-02-25 12:10:22.324555", but i am not getting the 6 decimal in output

just wondering if there is any limit for number of columns for dataset. i am getting the below error, when i have 49 columns Contents of phantom output file => RT_SC89/OshExecuter.sh: line 20: 26692 Segmentation fault $APT_ORCHHOME/bin/osh "$@" -f $oshscript >$oshpipe 2>&1 and when i h...

how to read an EBCDIC format file.

can anyone tell me what is this error i am using change capture stage Before_ds > ChangeCapture > file after_ds and i am getting this error: before_ds: When checking operator: Modify operator has binding for non-existent output field "CLASS_OF_SRV_NM" before_ds and after_ds both has same s...

me too was getting this problem. but proper partioning help me.

your target table may be in upsert mode. so do proper input stream partitioning on keys.

Just wondering if the branded ODBC version 5.1 works with Datastage version 7.5a.

Its working fine with DataDirect ODBC Version 4.2 but when I install the DataDirect ODBC Version 5.1, I am not able to use/connect datastage

Duke
where will i get the UtilityHashRead routine..
Please tell me in detail, how can i do this.

i need to pass some parameters in a job sequence. This parameter will be in oracle table. how can i read this parameter to pass in job sequence.
or how can i read the parameter from a file.