Is there anyway to use teradata utilities(bteq especially) on a Mac OS to run scripts? Does teradata studio express support bteq?
Harish, Yes. BTEQ on Mac OSX is available as part of the TTU Mac OSX released on the patch server under "MacOSX Suite". Teradata Studio Express does not support BTEQ.
I've managed to get Teradat Studio Express 14.0.3 and attempted to create a test database but got this message after finishing the wizard...'Creating connections to database has encouted a problem. Could not connect to database.' I click the details button but no further details show up. I believe it may be similar to the issue above about the unknown host error. Is there a web page that explains what to do to fix this?
@newb1, If there was an error connecting, the error exception will be in the Details of the pop up dialog (Problem Occurred) and will also be in the Error Log. To open the Error Log view, select the top toolbar Window>Show View>Other...Then select General>Error Log. Click OK. In the Error Log view you should see the line with the message, "Error creating Teradata Database connection...". Double click on the entry to see the full error message. As for how to fix the connection issue, it depends on what the error is. If it is 'unknown host' than the Database Server name or IP address is possibly not correct.
I was successfully able to load all 10 rows of the file you provided into the table you provided. I used Fastload, with , (comma) as the column delimiter, " (double quote) as the character string delimiter, and file encoding as ISO-8859-1.
When I was using the wrong encoding (UTF-8 for example), only some of the rows would get loaded.
I have a question regarding the JDBC Fastload/FastExport options. Do we have to install the full TTU (for example Teradata Fastload, Teradata FastExport) on the machine/computer before installing Teradata Studio Express for the JDBC Fastload/FastExport options to work? Or is everything included with the Teradata Studio Express installation? How about the JDBC driver?
Steven, You do NOT need to install TTU or Teradata FastLoad/FastExport. The Teradata Studio and Teradata Studio Express Load and Export features use the JDBC FASTLOAD and FASTEXPORT options. And the latest JDBC driver is bundled with Studio and Studio Express.