DSXchange

Tony Here is our odbc.ini entry with some changes. [DsnName] Driver=/opt/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmsss19.so Description=DataDirect SQL Server Wire Protocol Database=SqlServerDB LogonID=etl Password=etl Address=192.192.192.192,1433 QuotedId=No AnsiNPW=No

The create table is a flag. You need to generate the DDL. If you save the DDL then I think you can find it. Depends on how your wrote your routine.

Chuck is correct but index() will also find the second or third or nth occurance of a string. It is a little harder to get the equivelant of field 4 because you need to find where field 3 ends and then where field 4 ends.

You could get Parameter Manager. A 30 day evaluation is free. You could also do it with an update statement. These fields are multivalued so be careful. These fields are only valid in the ROOT record or where OBJNAME = 'ROOT'. INSERT INTO DICT DS_JOBOBJECTS (FIELD, CODE, EXP, NAME, FORMAT, SM, A...

dsjob -report Project JobName XML is the command being executed. This creates an XML file like: <?xml version="1.0" encoding="UTF-8"?> <Job Name="BuildAgencyHash" Desc="" Status="1" WaveNo="4" StartDateTime="2004-06-09T09:25:56" E...

Probably only Ray knows for sure but on early versions of DataStage and Universe the hostname is stored in the SCHEMA tables in the UV account. It might be hard to figure out what to update in there. I think the tablename is UV.SCHEMA. You probably need to do some hacking to figure it out.

You can hit limits in how long you are connected to a database. In Oracle I have gotten "snapshot too old" errors. The job took too long to process the data.

David, this is so much easier to navigate than ADN or other forums. You guys keep making it easier all the time. We do notice and do appreciate it. You guys do super quick fixes on small things too like moving posts from the wrong category. Very cool. Thanks again.

If your hash files are dynamic then HASH.HELP and some of the other commands do not work and are not necessary. ANALYZE.FILE is for dynamic files. I always prefer VOC entries. I always edit VOC. I hate SETFILE. Learn to use ED. It is useful for many debuging or hack tricks.

I figure out a head of time what to name my instance ids. In the EtlStats the sequence name or job name is the instance id. I know you can't always do that but if you can then it makes it easier. My problem is it is harder to reset these types of jobs. If one fails then it will not run the next time...

Please just Kim. Duke is my last name. Kim is my first name. I know Kim is a last name in other countries but I am not a formal type of guy. Just an old country boy from Oklahoma.

When you have a hash file that large you need a minimum modulo. Do a search this has been covered a lot. Usually if a hash file hangs it is not resizing. Dynamic hash files split one group of records into 2 groups to resize. So as the modulo grows from 1 to several hundred thousand then you had lots...

James You can download EtlStats which is several jobs which will extract job start and end times plus row counts and push them into a database. You download on Ascential's ADN or my tips page below. Save you lots of time. It will get row counts for all job, all jobs in a sequence, all jobs in a cate...

Mostly David and Walter. They are very good. Thanks Dennis.

You can use oconv(ColName,"D4-YMD"). There are several posts on how to check for a valid date. Do a search. You do not need it to be 9999-99-99. It can deall with 9999-9-9 or whatever. It is very flexible. If it not is valid then iconv() will have an error code in @STATUS or STATUS command. It shoul...