Search results for query: *

I see that unix shell variables can be referred to in bteq statements when the bteq code is embedded within the shell script. Is this possible in a batch script that will run in windows. If yes, can someone provide me with a sample script. Any info. on this is much appreciated. Thanks!

How can I suppress the SQL stmt in the export file, when using BTEQ export. I am wanting a pipe delimited file as output. Can someone please help.

Are nulls ignored by aggregate functions like count(columnname), max, min... in all versions of Oracle older and newer. Thanks.

Hi Happen to get this error message upon running an Ab intio graph. Would someone be able to explain why this would happen. Any help with this is much appreciated. Thanks!!! ABINITIO(DB15038): Teradata ODBC Error ABINITIO(DB15038): SQLCODE: 145 ABINITIO(DB15038): SQLSTATE: 08S01...

Hi, I am trying to convert minutes to Hour and Minutes through PL/SQL, for exmple 6 minutes should be shown as 0 Hr and 6Mins. Any idea as how to do this? Thanks!

Have a question regarding the design of a party account relationship table in a financial services model. Say there can be many parties associated with an account , and there is a role type column which defines the role a party plays on the account and there is a primary party indicator and...

Can someone please help me here. I would like to check if a volatile table that I am trying to create already exists. If not, I would want to create it, if it exists already, I do not want the script to fail. So is there a way to do this in a bteq script. Thanks!!!

I am using this command in a shell script to read the value for these variables from a file. IFS=" " tail -1l $HOME/extr_prd | read extr_prd_begin_dt extr_prd_end_dt Then I use these variables in insert stmts like , insert into tbl (begin_dt, end_dt) values ($extr_prd_begin_dt ...

A couple of questions. What are the factors that we need to consider to set the data block size for a table or is default preferred. Where in the data dictionary can I find the size of the data block as specified for each table. Any response is much appreciated. Thanks!!!

A couple of questions. Where in the data dictionary can I find the size of the data block as specified for each table. What are the factors that we need to consider to set the data block size for a table or is default preferred. Any response is much appreciated. Thanks!!!

With tbl1 being empty, can someone help me understand why col2 is null. SELECT MAX(extr_prd_end_dt) AS col1, COALESCE(MAX(extr_prd_end_dt), CURRENT_DATE-EXTRACT DAY FROM CURRENT_DATE)) AS col2, COALESCE(MAX(extr_prd_end_dt), CURRENT_DATE) AS col3, COALESCE(NULL...

I have a couple of questions. 1. Which is best suited for a datamart that will exist as a teradata database. The dimensional model or relational model. 2. We have an account table (2.5 million records) which has around 30 cols of which say 25 are stable (or we do not care for history on...

I have a couple of questions. 1. Which is best suited for a datamart that will exist as a teradata database. The dimensional model or relational model. 2. We have an account table (2.5 million records) which has around 30 cols of which say 25 are stable (or we do not care for history on...

Can someone please explain what are all the factors we need to consider to set the no. of sessions for a multiload script. Or can we just leave it at the default which is one session per amp. Any feedback is much appreciated. Thanks Krishnan

Hi In Teradata is it possible to load a timestamp literal which is in the format 'mm/dd/yyyy hh:mm:ss' into a timestamp column. Please let me know. Thanks Krishnan