DSXchange

thanks

Hello all (after longer period)

Do you know sth. about soundex function and it usage for non english language??
Can I use it with polish data?

Regards

when you configure your DSN both in .odbc.ini and uvodbc.config you are able to see these DSNs both while imprting meta data and while you try to connect to database using ODBC stage

you can set stream from ODBC2 as lookup to ODBC1 and in constraint you can pass only those records which do not have references in ODBC2

you probably set your settings in uvodbc.config placed in $dshome directory. You must type
in uvodbc.config placed in projects/your_project folder.

regards

I have also problems with loading dates into Microsoft SQL server. I changed date column from datetime to varchar - but only in DataStage metadata, in target I didn't change anything (colums are datetime, or timestamp type). Of course you must first prepare a proper format of date using Oconv(),Icon...

Hello! It's me again :) I have strange problem. When I try to create som job sequence (i.e. few JobActivity stages) in Designer, I can't open Propertis window of JobActivity stages in my client. I have noticed that I can't do this in Jobactivity, RoutineActivity and UserVariableActivity. In other st...

I have done it!

by the way, ArnD, is there some documentation, or comand list (such as CLEAR.FILE), avalible to use from DS shell?

Yes Arnd, you have completaly right - log hash is not recreated automaticaly. Now in RT_Log40 directory are simple text files. It was my quick solutuion! my second solution was that with exporting, deleting and reimporting job. Fortunately I have made backup before! I learned sth on my own mistake. ...

thanks Arnd! I used more dirty method: I have deleted manualy directory RT_LOG 40 and then I have manualy created directory RT_LOG40
It is not very cleaver and betiful method but it works
next time I will do it through command line

I must say that mu problem started when I was try to display very huge LOG (1,9GB) in Director and Directror stops responding. Is it possible that this caused my problem? and I 've extra question: can I safely delete this file directory RT.LOG40? Or how can I clear this log, but without using Direct...

yes NLS is installed

yes, my dsenv is ok!
I have tried uvregen, but it doesn't work!

finally i reinstall DS server and now it is OK, but what was wrong and why, I still don't know.

If you have any ideas what was wrong and why please write it

regards

# start the cache daemon if configured val1=`bin/smat -t|grep DISKCACHE|tr -d " "|cut -d= -f2` val2=`bin/smat -t|grep DCWRITEDAEMON|tr -d " "|cut -d= -f2` ----> if [ "$val1" -gt "0" -a "$val2" -gt "0" ] then # cache daemon requested to sta...