DSXchange

Luk

you can use GetNextKeyValue routine in transformer stage to generate integer number sequence wchich you can link with old keys and use it as surrogate keys

Luk

you can stop DS server

Code: Select all

./bin/uv -admin -stop

check are there some processes still running

Code: Select all

ps -ef | grep dsslave (or dsapi)

kill processes and start DS server

Code: Select all

./bin/uv -admin -start

Luk

is it possible to export jobs made with DS into some code (i.e. C++,VB ....) and then run them without having DS installed??

I suppose that is impossible

but I want to make myself sure.

Luk

Can you post the solution you have successfully implemented so any future search for similar requirements can make use of it.

Sainath - solution is already posted. mhester gave it!!!

Code: Select all

elect COLUMN_NAME from information_schema.columns
where table_name = 'TABLE_NAME'

Luk

thanks - it is working

Luk

no!

I have ODBC stage and I am connecting to MSSQL server. I want to get column names from SQL server as data (in rows) and use them - put into target!

Luk

Is it possible to catch columns names from SQL querry by ODBC stage and put it i.e. to a file??

Luk

You already gave solution - as I've mentioned you had right!!

set of columns which I used as PK in hash file wasn't 100% unique (there was an update on few records in hash) . I have added 1 more column as key and everything is unique and number of rows i hashes is correct!

Regards

Luk

OK

problem is solved

thanks you all!!

Regards

Luk

Yes that is true - I have noticed that pair of PK columns is not 100% unique !!! if you ran the job and created the hash file with just one column as the PK and later added the second column the file will only use the original definition, I am using checbox "create file" and checkbox "...

Luk

Is it possible to overwrite surrogate key column (made by GetKeyNextValue) in hash when I have PK build with two columns (key is unique only when you take both columns, if you take only one they won't be unique) ??

Luk

Hi! I have strange problem. I have got transformer and output of transformer is connected with two different hash files. As input of transformer I veve got sequence of surrogate keys( made with GetKeyNextValue) colA, colB and colC. I'm putting key column, colA as PK, colB as PK into firs hash - key ...

Luk

HI!

What kind of problem do you have with connection to Sybase IQ??

Luk

dsadm - is default user when you don't type another one during root installation

Luk

Hi!

I have got following warning:

DataStage Job 80 Phantom 15479
Program "JOB.526962533.DT.1361844072.TRANS3": Line 157, Variable previously undefined. Zero length string used.

What does it mean??

Regards

DSXchange

Search found 133 matches

jobs export

Columns name from ODBC as data

Writing data into two hash

Warning: