DSXchange

Sure. It is built into the job. The job can clear hash files before loading them or DELETE and CREATE. This is very effective. You can even size the hash file properly which will speed up loading the hash file.

There are 2 things going on here. You can run these commands under the control of the Universe shell (uvsh) or Korn (ksh) or Bourne shell (sh). Code: $DSHOME/bin/uvsh "select * from DS_JOBS" > /tmp/deletemeplease.txt Has to be under the control of ksh. Once you run uv as a separate command then you ...

You could do it manually dir -1 *dsx >files.txt

Edit files.txt and add the import command to each line.

IBM would not be happy if someone published a way to decrypt these values.

I agree with Craig. I have done this in the past and it ignored the single line and worked as expected in PLSQL.

Here are some links which should help.

http://www.datastagexchange.com/Newslet ... enting.htm
http://www.dsxchange.com/viewtopic.php? ... =etl+audit
http://www.dsxchange.com/viewtopic.php? ... =etl+audit
http://www.dsxchange.com/viewtopic.php? ... =etl+audit
http://www.dsxchange.com/viewtopic.php? ... =etl+audit
http://www.dsxchange.com/viewtopic.php? ... =etl+audit
http://www.dsxchange.com/viewtopic.php? ... =etl+audit

Remove the -- comment and you tell us what happens.

There is a hosts file that looks up IP addresses. It is usually in C:\WINDOWS\system32\drivers\etc. If you have an entry like 10.10.10.10 kimhp kimlaptop Then kimhp and kimlaptop get transformed into 10.10.10.10. ping 10.10.10.10 ping kimhp ping kimlaptop Are all doing the same thing. The ping comma...

I would take your select and create a temp table with it. Import the metadata. Change the metadata so the fields that need prompts for are keys. Build your ODBC or OCI lookup then switch it to user defined. This will save lots of time.

Do you know how to CREATE TABLE using a SELECT statement?

Post your code.

Your syntax looks correct. Maybe your server is not in your PC host file or your password is incorrect.

Why not use dsjob?

No you cannot. A routine can only be called from a BASIC program or using DsObjects.dll. A job is a BASIC program. So a job would work. The problem is you need to know a lot more about Universe to do this. In the old Universe world we would create BASIC libraries. We would store this in Type 19 hash...

I am not sure you will get a response on this. It sounds like an interview question. It is too generic to have a good answer. Everything was difficult in the begining. Not sure too many things are difficult now except managing people's expectations. People are the problem now probably always were th...

Write your own. DSX files are not that complicated. Here is one in BASIC. Modify it. * ----------------------------------------------------------------- * KgdParseDSX(Path, FileName, JobsToSkip, CatOnlySw, DebugSw) * Decription: Parse DSX File. * Written by: Kim Duke * ----------------------...