Search results for query: *

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...

Hi all Does anyone know where I can get teradata.jar (JDBC driver) that will work with the Teradata demo? All the drivers on teradata.com require that Teradata's patch level to be at or above 5.0.0.23 for v2r5; the demo is at 5.0.0.11... For info - I have jserver running on the default port...

Hi all I am trying to work out why my TDAT demo cannot 'see' my VC++6 installation (for use in Stored Procedure compilation). As far as I can tell, VC++6 was installed in very standard way, so I can't think why the SP compilation process would fail to find it. Assuming that some registry key...

I have an InstallShield installer which checks the currently-installed Windows NT service pack level before proceeding to install. Does anyone know where the installer is likely to look for this information? I need to know because I've just upgraded to WinXP SP1 and now my installer says my...

I beieve the Silverrun range of tools support Teradata, too. BRgds JG

By way of an example, if I had a table based on the following definition: Create Set Table test_tab (test_col1 Integer NOT NULL ,test_tstamp Timestamp) Primary Index (Test_col1); A view that should work for you in BI/Query might be: Create View test_tab_view As Locking test_tab for...