DSXchange

ray.wurlod wrote: You might like to mark this topic as Resolved, then. ...

Tried several times but kept getting an error

Smoker

Greetings again I have been playing with dssh and found a problem that I can not figure out. The command is JOB="VertexBefore" $DSSH "SELECT * FROM DS_AUDIT WHERE INSTANCE='$JOB'; " > /tmp/file When from the command line the output looks good like this... Class\ID........ 2\Verte...

There is a table called DS_AUDIT that records this information. It contains a nested table caled MODS that records the date/time and by whom modified. [url=http://www.dsxchange.com/viewtopic.php?t=9 ... Unfortunately I can not afford the cost of a membership (my employer won't pay). Is there any wa...

kcbland wrote:Oooo, don't think that's in a support API. We usually try to get info from DS_AUDIT, but that's kind of proprietary stuff. Search the forum for DS_AUDIT to see what other folks are doing.

Ah good stuff (I think)... will research that.

Thank You kc

Greetings Folks

I am trying to find a way (commands) from the (AIX) command line that will show me the last time a job has been compiled and/or modified.

I've gone through the dsjob command and options but no luck there.

Can anyone point me to some other commands that might help.

Thanks
Smoker

Well I've got a file with the first record having the count of records that should be in the file. So without a lot of detail I am trying a method where a hash file would have the same number of records but containing that count. Then with another hash file having a list of records containing the co...

OK so this is my output link derivation...
What would be the stage variable (Dup) derivation ?

I have tried adding another column with @OUTROWNUM and that being the key so that it would be unique and not trash records cause of the key field.

I am just not sure how to duplicate the first record to the output.

I suppose I could use a seq file. it's just that I have more stages afterwards and thought a hash file was the way to go.

Greetings Folks

I've got a file (file1) that has the first record that I would like to duplicate into a hash file as many times as there are other records in the file (file1).

Is this possible with a transformer ?

I've got it to the point of getting a hash file with the first record (containing the record count, 3 in my example) and a second hash file with the data records. But where I am not able to move forward is the next step. To have some kind of logic that would say... if the hash file with the record c...

Greetings Folks This question will prolly tell oh so much about how new I am to DS but need to start somewhere and here looks like a great place :) I have a file being sent to me that has several records. The first record is simply a count of how many records (lines) are to follow. What I am grappli...