Recent content by jgrogan

SL23 Oops - I only tried recursion with 20 entries - it has a depth limit of 127. Sorry. Please use the other (non-recursion) version. Also, it is not necessary to generate a dummy table with 1000 integers; just reference a table with over 1000 rows in it. Use row_number() during generation...

Hi SL23 I am curious why you would need 1000 copies of the same table, but... If you have recursive queries available (V2R6.2 works, YMMV with earlier releases): WITH RECURSIVE temp (num) AS ( SELECT 1 FROM dummy UNION ALL SELECT num+1 FROM temp WHERE num < 1001 ) SELECT 'CREATE SET TABLE...

Dakota81 Have a look at Talend Open Studio - it is a free, nice to use ETL tool (based on the Eclipse Platform) that runs on Windows and Linux (with GTK). You will need a Java Development Kit installed. Jobs can be built to copy from Access to Postgres (and back again) with data...

Hi Is it possible to 'script' an edit (i.e. batch edit) an existing crontab? If so, how would I go about it? I am effectively asking if 'crontab -e' is scriptable, using sed-like syntax to edit a line (to add a '#' to a scheduled command in the crontab) to stop execution of that command...

Thanks RivetHed - works a treat! JG

Yes. I have not seen any examples that suggest otherwise. Thx.

Hi all I have a column in excel holding things like abc delimiter def delimiter ghi the 'deimiter' is literally the string 'delimiter'. I need to add a sequence number to each occurrence of the word 'delimiter' in the column, giving something like: abc delimiter001 def delimiter002 ghi ...

Dieter I concede it probably wouldn't be easy, but even Filer was written in something. That aside, I find it limiting that details of a key feature of the database is unavailable in the DD/D. Almost everything else is there... Kind regards James

Thanks Dieter, You just confirmed by worst fears. I don't suppose you have the C struct for a table header handy...? :( Regards J.

Hi all Is there a way to determine if a referential constraint is declaredWITH CHECK OPTION or WITH NO CHECK OPTION - programmatically - without writing a parser for the originating DDL? This attribute appears to be lacking in the Data Dictionary tables, which leads me to think that the value...

Hi Problem solved. It turned out that Finder was crahing on every shutdown. It would appear that Tiger doesn't like the way Tinkertool implements the "Display hidden files in Finder" option. I unchecked this option in Tinkertool and Finder hasn't crashed since, and I no longer get 'rogue'...

Hi Raj As the command shell (cmd.exe) does not 'process' your fastexport script, it has no opportunity to substitute your variable. So, something like "...file=%mypath%.fexpfile.dat" will be presented to fexp.exe exactly as you typed it. You will need to edit your script in line as part of...

Hi Brad I have designed and built something like this as a bespoke solution for mainframe DB2 to Teradata, but not for the UDB variant (presumably running on Unix). In this context, there are subtle but notable differences between the M/F vs. UDB DB2 variants, but the principles are broadly the...

Hi all I have just upgraded from 10.3.9 to 10.4, then patched up to 10.4.2. Under 10.3.9, when Finder started up I was presented with only a Finder menubar. Under 10.4 (and 10.4.2) I am presented with a Finder menubar and a Finder window (as if I had pressed option-N). Is this normal under...

Hi tdatgod I'm sure the files are on the CD; I checked one of my other boxes running the demo and the NCR\terajdbc folder had the elusive \classes subfolder present. My latest install doesn't - very strange - almost as if the JDBC driver installer got bored! Anyways, I'll pull the \classes...