DSXchange

No easy way without a reverse engineering hack effort. The easiest is to add the column names as the first line in the output sequential file (if it's delimited -- highly recommended). Just check the box in the stage to do this. Now, all you need to do is "head -n1 filename" to get the list.

Derive your output columns and put them in an outbound good link. Put the same derivations and columns in an outbound exception link to file. Create a constraint for the outbound good link that is: NOT(ISNULL(inlink.col1) OR ISNULL(inlink.col2) OR ISNULL(inlink.col3) OR I...

You're going to end up with two rows. How are you identying the existing row if the SSN is different in the source? If you have an alternate key, then usage of the SSN as a pseud-surrogate key is a big mistake. If you have a natural key that is unchangeable, then I suggest you simply use that to ass...

Sure, use the constraint on an output link to check for the NULL condition (ISNULL function). Set the Abort after N rows limit on the output link to 1, so that the first row to satisfy the constraint condition will abort the job.

Just remember, it's not how long it takes to get the first row in a query, but how long it takes to get the last row. You need to run this query and spool the entire results to get the full appreciation of its runtime. You will need to tune your 3 table join. Ogmios has given you a headstart, and ye...

You can issue a command to manually delete rows from the hash file DS_METADATA. THIS IS VERY DANGEROUS, BUT WITH CARE WE CAN TRY TO FIX IT. If you're feeling brave, from your DS engine prompt you can issue the commands: SELECT DS_METADATA LIKE "unnamed..." which should give you an active s...

Are you selecting or loading? If you're selecting, what kind of query are you doing, is it a table dump or a complex join? Are there a lot of bytes of data to be returned? 1000 columns will spool at a different rate than 10 columns because the measurement of performance is not row based but chars/se...

Let's cut to the chase: If Ascential actively "certified" people outside their organization, that would be an admission that there are qualified people other than those within their organization. Now, if your responsibility is to keep your resources billing at the highest value possible, would you l...

I hope you have your projects in some version control. My obvious guess is that things are foobared and you're going to need to setup the projects again and re-import. Have you tried tech support, as this sounds like it could be an issue someone else should have encountered.

Good luck.

What's the error message? Are you even getting into some projects? Have you checked the permissions on the project directories/contents?

How do you test for wisdom? I read somewhere, probably on Ascential's site, that certification is being offered by Ascential. If I remember correctly, you have to petition Ascential for recognition and have certain qualifications, namely successfully deployed an Ascential based solution as well as c...

Just issue the truncate statement from a sqlplus script. This will preserve the table, grants, indices, and statistics. The dropping and recreating of a table is not a great choice for the above mentioned reasons.

You can write a routine to be called in the after-job routine or in a controlling job. The appropriate API's (DS*) are in your DS BASIC manual. The steps are to attach to a job, get its stage list, loop thru the stage list getting the link list and for each link the row count. You'll have to learn a...

You cannot have multiple processes writing to the same sequential file, period. There's nothing that can be done about this because it's a block writing issue on all operating systems. You have a few choices: if all streams are in one job use a link collector; if separate jobs use a hash file to col...

Hi Ken, I tried your way, it doesn't work either. Here is the error message: Attempt to convert String value "2004-06-09" to Date type unsuccessful The Oracle stage adds to_Date(columnname, 'YYYY-MM-DD') to your column in the auto-generated SQL. If you're using auto-generated SQL, then make sure yo...