DSXchange

Greg

I think you are correct, this is a good solution for BASIC. How would you do this in SAS?

Another solution is to create a table of days or use a day dimension table. Join this input table to the new day table and count how many records you get by month.

Jobs which have warnings finish with a different status code than jobs without warnings. This is so you can trap warnings and stop processing if necessary. If you add a contraint on the output link that says not(IsNUll(link.col)) then this will stop trying to write these records out therefore no mor...

Put the word PHANTOM in front of it.

Ray

I am just guessing because the question was too vague.

DELETE FROM H_XOL_DENORM WHERE PARTITION_ID = 1

Should work. What is your error message?

Try



Make sure this hash file has all the dictionary items.

The hash files used by DataStage mostly start with "DS" like DS_JOBS, DS_JOBOBJECTS and DS_METADATA. The files which start with "RT" like RT_CONFIG109 and RT_STATUS1078 are associated with jobs. Each job is assigned a surrogate key called a job number. This job number is concatenated to the RT file ...

You can use SQL DELETE to delete these records. No need to write BASIC. You can use ExecTCL to issue the command. If you really want to know what this program is doing then I will explain it. The VOC is the Universe equivalent of a system table. A F in field 1 of a VOC record is called an F pointer ...

Vincent

This sounds like job interview questions. We really should not answer job interview questions.

Sorry, Ray. My bad. Anyway it is very cool.

Do you need this information on all jobs or just this job? What are you doing with this information?

Sorry, you are correct. It is not available to the forum.

If you are using DYNAMIC hash files then you do not need to size them except to garbage collect. They are the default hash file type. You should have a minimum modulo on all large dynamic hash files. ANALYZE.FILE MyHashFile will tell you the current modulo. The performance gain for doing other hash ...

Ray posted some code where he dumped DS_METADATA file into XML. It was all written in BASIC. Very clean easy to read. Do a search.

Before some of the new features in DataStage these tools would ftp a file, wait for it to finish, start a DataStage job, wait for it to finish and then ftp the new DataStage file to some other machine. That is still not too easy in DataStage without a shell script. These tools are great at coordinat...

Hey Craig,

What happens when ship carrying blue babies crashes into ship carrying red babies? Are they smurfed or marooned?

You are right I think it wise for you not to comment.