DSXchange

I think it should be:



And it works great if done right.

select EVAL DS_JOBOBJECTS."@RECORD<6>" AS FILE_NAME FMT '45L', DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L' from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE in ('CSeqOutput','CSeqInput') and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO group by FIL...

Ray

We were promised notes for the first class. What happened? I know you are not busy or anything.

Run this routine in test mode. Normally the value has either CrLf or @FM in it. You need to do more than Ans = Trim(Output) to make it a number. When testing add some print statements like: print num(Trim(Output)) print dcount(Trim(Output), @FM) I would think it probably needs to be Ans = Trim(Outpu...

This should work. What does it do? You should be able edit the COMO file

ED &COMO& BUILD.LOG

Ray

It did not work for me either. Ds7.5.1A

This routine does not work this way. If you look into the dsinclude directory in your project. Edit JOBCONTOL.H. Deffun DSGetLinkInfo(JobHandle, StageName, LinkName, InfoType) * Possible Link InfoType tokens: Equ DSJ.LINKLASTERR To 1 ;* Last error message reported from the link Equ DSJ.LINKN...

Nice one, Ray. Learn something all the time.

Ray is correct. You can do the same in BASIC routine.Your select needs to be all on one line. You can open "&UFD&" and read the script in that way.

localuv exists without having to create it. You can use this as a DSN and ODBC with Universe itself but it does not work as an external ODBC connection.

What is the reason you copied it into the VOC?

You need to telnet into your DataStage server and connect to the Universe shell.

Do a search for TCL commands.

I have posted this code before. Replace :1 with your routine name in upper case. This is part of EtlStats. You can run this and have it email you the results by running job GenHtmlFromSqlDriver. Parameters: (Take defaults on all but these) SqlScriptsId = DsSearch1.sql SqlDsn = localuv SqlUser = leav...

If you want to find a string then use INDEX() in BASIC. Do a search. How to use INDEX() in BASIC has been covered a lot. You need UPCASE() or DOWNCASE() to make it case insensitive.

If you are using parameters to feed to the bat file then it is broken.