DSXchange

Like this post for instance.

I paste it into the command line to get mixed up casing, then copy and past that line again to the command line and execute it. Just a couple of clicks, but it does take a bit of getting used to. You know, I used to do the same. Then I saw Kim's video on detailed ETLStats Installation. I saw him us...

Untill someone comes along and points you in the right direction, you can try doing a search on "IDOC". See if any of the posts help. You can go through them, read about what stages are used. Go to their individual help guides.

ray.wurlod wrote:Personally, I like the default. Probably because I'm used to it.

I bet you dont copy paste onto the uv session. For folks who do, its a pain and just makes life a bit easier.

You know you could rerun the Server installation and have it installed in all projects at once, rather than one by one using dspackinst... yes? This would also update the 'template' project, such that any new project created after this would also have the plug-in. Craigs suggestion seems more effec...

nvuradi wrote:one more thing i dont have a transformer in my Job...

Get one. Abort "after n rows" is a functionality present inside the px transformer.

I used to have this problem. I used to delete the derivation column in the columns tab, of the DRS stage/ODBC stage.

First of all, DB2 does not have TRUNCATE. Either its a delete or its a load from /dev/null or import from /dev/null.

For DML's, its the same. For more specifics do a google search.

It will work in UV but you have to type it out because its case specific. Type

and then you can paste it as it is.

Wow, the entire database huh? What if you do a simple select from one view, no joins?

I havent had much experience with reading xml files with the sequential file stage. Actually none experience. Maybe some one else can throw some more light on it.

True, but its worth a shot. But maybe your right. Nevermind my blabbering y2ariyas.

Welcome Aboard Does this happen every time you run the query with datastage? I quick search in google on the error message revealed that error 220 is due to losing connection. For some reason you are losing connection. Get your DBA invovled and then run your job. See what your DBA can detect on the ...

ray.wurlod wrote: I also enjoy dipping into dictionaries of indigenous words, particularly Australian aborigine and Maori; and etymology is another passion.

No wonder sometimes we have to take a peek in the dictionary while reading some of your posts