Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jgrogan

    create 1000 tables using script

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

    create 1000 tables using script

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

    program to move data from MS Access to Postgresql

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

    using batch process to edit live crontab

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

    selectively add sequence number to an Excel 2003 column

    Thanks RivetHed - works a treat! JG
  6. jgrogan

    selectively add sequence number to an Excel 2003 column

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

    selectively add sequence number to an Excel 2003 column

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

    Identifying WITH [NO] CHECK OPTION status programatically

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

    Identifying WITH [NO] CHECK OPTION status programatically

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

    Identifying WITH [NO] CHECK OPTION status programatically

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

    10.4 Tiger startup annoyance - help?

    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'...
  12. jgrogan

    Passing the path as a variable in Fast Export

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

    DB2 UDB to Teradata

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

    10.4 Tiger startup annoyance - help?

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

    teradata.jar for Teradata demo

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

    teradata.jar for Teradata demo

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

    5547 Error: TDAT Demo: VC++6 installed

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

    Registry Key or location of current service pack level

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

    Case tools for Teradata...

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

    Qualify a Timestamp in Teradata

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

Part and Inventory Search

Back
Top