DSXchange

The derivation is used when Auto-generated SQL is chosen. If a column's derivation is blank, then the column name is used. The derivation is always the metadata name dot column name. Therefore, the metadata name must be either schema dot tablename or just tablename in order for the Auto-generated SQ...

What do you mean by similar? Are you trying to remove exact duplicates or pick out a representative row for a repeating group of key values? For the first, simply spool to a text file and execute a "sort -u your textfile > newtextfile" statement. Read the data back out from the new file and continue...

3 simultaneous processes writing to the same file will produce malformed data, as all operating systems buffer writes. You will not get "rows" in the file, because data is written in bytes. There's no "row" concept. If you need a "collator" then use the link collector stage. If you need 3 non-simult...

This preserves the file, permissions, and owner.

The first question to be answered is always: what else is running on the DS server? Second is: what is running on the database server? Third is: have you looked at your job processes cpu utilization? Fourth is: are warning messages spewing into your job log? Fifth is: what does your load SQL look li...

You may not have permissions to write to to the project. Confirm the installation for umask setting, project directory permissions, and your userid group permissions.

DS BASIC function INDEX searches a text string for a string value and returns the starting character position for a given occurence.

All source data columns of data type DATE should use a TO_CHAR function with a mask of YYYY-MM-DD HH24:MI:SS. DS automatically puts this on the SQL for auto-generated SQL, but since you hand-wrote your SQL you must do this. All target columns of data type DATE or TIMESTAMP should use a TO_DATE funct...

I actually have a Batch job that exports job design information for pre-DS 5.0. It writes csv files of the internal job design library. If you're interested, let me know. I make no guarantees, it's 6 years old.

Then he/she has publicly stated their expertise exceeds the level for helping others. Then please do, I'm going on vacation 3/28 to 4/2. I happily relinquish my North American "shift".

accchh. Missed that part.

WOW! After 10000 posts someone still comments that Ray is not being forthcoming and helpful. The obvious solution, sir or madam, is to post your own responses to questions and help out if you feel the Premium Posters answers are not to your "quality" or "liking". There's no rule that only Premium Po...

Or, import into 7.5 and use the methods I posted.

Use DS Manager in Extended Job View mode, open each job in Designer and use the generate report feature.

Retrieve it from your last export. Tip: Export your development projects daily and store.