DSXchange

chulett wrote:I'm assuming this works under Vista as well, yes?

My answer to this question is the same as your answer to a SQL Server question

(Which is, I dunno, try it and see. But I wouldn't think the underlying file system architecture changed dramatically, if at all, between WinXP and WinVista)

Hi, Off topic but wanted to share... A really useful freeware Windows utility I use ALL the time: Ninotech PathCopy 4. It's an extension to Windows explorer that allows you to RMB a file and copy Short/Long/UNC/etc path to the clipboard, for further copying into code, email, etc. Google "Ninote...

Thanks Craig. As always, much appreciated. 1) Yes, the double "My Documents" is correct. I put a lot of stuff under "My Documents", including "My Documents" :) So it's a directory I created. I'm sure the path is correct - if I find dsdesign.exe doesn't handle quoted lon...

So I did a search of DSXchange :wink: , downloaded Kim's utilities, and edited DsJobReport.bat for my local environment. Questions: 1) Does dsdesign.exe tolerate long file paths as long as they are properly quoted? After editing Kim's batch file, here is my command line: "C:\Program Files\Ascen...

Hi,

This is minor but...

Is there a way to change the font used for code in the DRS Before and After tab? My code reads easier with a monospaced font.

Thanks,
Scott

Okie-doke, thanks...

Hi, In my sequential file stage with 120 columns, how do I globally change "Incomplete Column" from "Error" to "Replace + Warn", rather than the oh-so-painful one column at a time? Thanks... P.S.: My first change was from "Error" to "Retain", then I ...

As always, thanks for the help Craig. Genuinely appreciated. In case others might find this useful, here is my final (test) script. It was slightly tricky getting the here document output captured in a variable, but Google saved the day: #!/bin/bash cd $DSHOME FOUND=$(uvsh <<EOF | egrep 'records lis...

I tried this from my home directory in a bash shell: sbass1:~ > uvsh <<EOF > LOGTO DEV_GGS > SELECT JOBTYPE,NAME FROM DS_JOBS WHERE NAME='TestJob_Seq' AND JOBTYPE='2' > EOF This directory is not set up for DataStage. Would you like to set it up (Y/N)?LOGTO DEV_GGS So, is there any way to invoke uvsh...

Thanks Craig, And while you do need the 'PTERM' statement to make an interactive cut/paste work, Since command recall (often bound to up-arrow) doesn't work (which is fine, I think other SQL utilities are similar), I mark the text in Putty, then paste it. And the default behaviour transforms the tex...

(1) Not easy. You could enter the uvsh then issue a "LOGTO {Projectname}" command. (2) "PTERM CASE NOINVERT" will do the trick for you. OK, in the shell, I cd to my project directory. uvsh "SELECT JOBTYPE,NAME FROM DS_JOBS WHERE NAME='TestJob_Seq' AND JOBTYPE='2';" | e...

Hi, I'm trying to do something similar: I want to conditionally reset a job, but not a sequence. Rationale: An aborted job needs to be reset before it will run. An aborted sequence does not (at least in my environment - I think that's what Aborted/ Restartable means in Director. But, resetting the s...

Hi Craig, Thanks for the ideas. Follow up questions: 1) DS is on Unix, SQL Server on ... drum roll please ... Windows ;) So if I did create a sequential file for bulk insert, I assume it would have to be ftp'd to Windows or otherwise accessible from the SQL Server machine. A quick read of SQL Server...

Hi Craig, I just assumed looking up for every record, when so few required the lookup, to be non-performant. So I created two versions: 1) split the stream, lookup only on the relevant stream, recombine via link collector (and requisite interproces buffering), and 2) "seed" two new hashed ...

Hi, I have a job that: * Extracts data from Sybase * Performs two lookups (one against the target table for target SK lookup or creation (KeyMgtGetNextValueConcurrent), one against a calendar hashed file for date SK lookup * Writes the result to a target table (DRS stage, SQL Server table). * Sends ...