DSXchange

Hi, Actual problem statement: I need to do a QC check on our DEV project before migrating to TST. In particular, I need to know which jobs have hard coded physical paths or database connection strings (eg. db instance, username, password). All of these job parameters should be "$PROJDEF". ...

1. Is there any chance of getting your source data changed? The whole purpose of a field delimiter is it's not part of your data. So get the comma field delimiter changed to ~, ^, |, etc. 2. Since your data appears to be name=value pairs separated by a delimiter, use the FIELD function to parse your...

Doh! Sorry for the misinformation...

Hi, I need to convert the '04/01/2009' date in string format to '4/1/2009'. Basically, i need to trim out the leading zeros using Trim functions. My code: Trim('04/01/2009'[1,2], '0','L') :'-' : Trim('04/01/2009'[4,2], '0','L') :'-': Right('04/01/2009',2) Output will be 4/1/09. Instead of using thi...

I typed "help start" in a cmd window: Starts a separate window to run a specified program or command. START ["title"] [/Dpath] [/I] [/MIN] [/MAX] [/SEPARATE | /SHARED] [/LOW | /NORMAL | /HIGH | /REALTIME | /ABOVENORMAL | /BELOWNORMAL] [/WAIT] [/B] [command/program] [parameters] &...

The way I might approach this is a script which gets a filename as an argument, then echos each line of that file to the console, appending the filename to the beginning or end of the line. You set that script as a filter for a sequential file stage, then use parsing functions in DS (eg. the Field f...

So? The -lognewest allows you to find the most recent "started" event, and you can use that information to filter what you get back from -logdetail. It's probably easier to do this with a DataStage BASIC routine than with dsjob commands. Hi Ray, -lognewest yields: dsjob -lognewest MY_PROJ...

nagarjuna wrote:Are you trying to capture the lateset log ? May be you can try using dsjob -lognewest.

I need the log details of the last job run. I'm getting a lot of data truncation warnings writing to the database, and need to pass this information to the provider of the source data so they can clean it.

Hi, I did search on "dsjob -logdetail", plus a lot of hacking with dsjob, before posting... How do I get dsjob -logdetail to list the log from the last job run? IOW, how can I derive the <first event id>? The only way I could see is issue dsjob -logsum <project> <jobname>, capture the firs...

The 'direction' would be controlled by constraints. Perhaps leverage stage variables, one for each field to validate. Valid = 0, Invalid = 1 and lastly sum them. Good row constraint: sum = 0, reject everything else. Something like that, anywho. :wink: I take this exact approach in code I've written...

Sorry if this has been discussed before. I did search before posting. I have a job like so: SEQ1 --> XFM1 --> SEQ2 --> (more downstream XFM's -->) With the volume of data in SEQ1, plus the code that's running in XFM1, the red bit takes a long time to execute. In development, when I'm changing the do...

You would have to write a batch file to call your command line query tool of choice and then use ExecDOS directly or DSExecute in a routine to execute it. ... That's what I've done now. However the batch file always returns a positive result since even if the SQL query fails as far as DOS is concer...

Caveat: I only have DS 7.5.x Server perspective. One approach: read the entire line as one long string, use a loop plus the field function to extract each delimited field, exit loop when done. Second approach: use a sed or awk script to normalize your file to the largest common denominator. If your ...

what .\NUL means? http://www.google.com.au/search?sourceid=navclient&aq=t&ie=UTF-8&rls=ADBR,ADBR:2008-20,ADBR:en&q=windows+null+device The sequential file filter stage pipes the Filename thru the Filter and reads the output. So, if you pipe the null file into your filter, your filte...

2). It's better to have SAS server installed on the same box as the DS server. This may be incorrect if you have SAS/Share licensed. Do you? If so, you should be able to access your SAS data "across the network". It may still be "better" to have SAS on your local machine, just a...