DSXchange

If i import the table definitions of a table, will the synonyms, indexes, constraints be imported too. No. It's not a modeling tool. If not, while running a SQL query from DS do i need to specify any particular command to involve indexes and all other related stuff with the table !! No, not for Dat...

:roll: This thread began with the topic "auto clear log", morphed through clearing &PH&, and is now talking about clearing the status file. These are all different things , people!!! And they say 'You don't tug on Superman's cape You don't spit into the wind You don't pull the mask off the ...

How can i clear status file by script. I have an option in DS "Job --> Clear Status File" which clears all the instance of the job.I wanted to clear all the instances which ran one week ago? how to do that? 1. Log into the server using the dsadm user; <snip> Not sure how that's a scripted solution.

That too.

Tell me about it.

You, however, are the epitome of someone out entirely too much.

It's not so much that 'last' is important, but that the ordering of the reject link is important - especially if all you've done is check the Reject box. That's because the rules for its use are positional - it means I want data to go down this reject link if it hasn't gone down any other link yet. ...

You can't... at least not directly. You've only got the three choices listed for Line Termination that you've seen: UNIX Style (LF) DOS Style (CR LF) None One option would be to preprocess the file and replace the pipes with a 'normal' line terminator. Or look into doing the 'preprocessing' directly...

I ran the job and configured it to abort after 1 warning. I just wanted to take a look at the problem record. However, nothing made it do the reject file. I configured this reject link using a transformer and checking 'reject link' inside the transformer stage constraints window. Hmmm... I know tha...

You didn't manage to send all of the problem children down only the reject link. How did you configure this 'reject' link? Did anything make it into the reject file before your 50 limit triggered the abort? (Which is what I assume happened) Unless you will generate bazillions of errors, you might wa...

Thanks for posting the resolution. And I'll keep an eye out for the video... 'Transformers Gone Wild!'.

Please try to keep discussions of your problems in one place. Why start this post and tag the same issue onto the end of this post?

No-one enjoys trying to carry on multiple conversations on the same subject at the same time.

Wake me when it hits H-PUX.

No, the original 'culprits' were the 50 put messages. View data introduced the 'read' errors during diagnosis. As far as I can tell.

I was also looking for a working piece of routine that returns the row count . I am using the above routine in the Transformer in a very simple job but the job is not getting completed , it remains in the running stage and ultimately I had to abort the job. As noted, it is not meant to be used in a...

You don't. You extract all values from a flat file and then pull distinct values from that. A couple of ways off the top of my head... 1) Sort the incoming flat file data and then use stage variables to only let the first value in any 'group' through. The sorting can be done using a Sort stage or th...