#DateForumTypeThreadPost
1020 Feb 2008 @ 12:25 PSTUDAReplyHow to handle %rowtype(oracle) in teradataBoth %TYPE and %ROWTYPE are used to define variables in PL/SQL as it is defined within the database. If the datatype or precision of a column changes, the program automically picks up the new defin...
915 Feb 2008 @ 06:36 PSTUDATopicHow to handle %rowtype(oracle) in teradataA SAMPLE CODE IS GIVEN.DECLARE Emp_row Emp_tab%ROWTYPE; /* declare a record matching a row in the Emp_tab table*/Any idea how to implement this in Teradata
812 Feb 2008 @ 11:02 PSTTrainingTopicTeradata MaterialsThere are some useful links of Teradata materials in the following blog.http://upendramishra.blogspot.com/
712 Feb 2008 @ 05:37 PSTTrainingTopicDemo CDI have ordered the demo version 2 months ago.But it has not reached the specified address yet.Can anyone guide me about getting a demo CD.Thanks & RegardsUpendra MishraIndia
628 Jan 2008 @ 12:18 PSTConnectivityReplyHow to write UDF to handle operating System I/O operationsRedesigning our business applications to work on Teradata is an option.So that we can the take the advantage of its capabilities.But we are experimenting on all the probabilities to retain our mo...
528 Jan 2008 @ 12:06 PSTDatabaseReplyOracle to Teradata MigrationThere is a print statement which gives the output to stdout. In Unix environment ,stdout is having a file descriptor 1 as unix treats every device as a file. We can redirect it to any file using un...
425 Jan 2008 @ 01:31 PSTConnectivityReplyHow to write UDF to handle operating System I/O operationsAs of version 7.x we can write external procedures and UDFs in C or C++.Anyone having prior experience in writing these types of external procedures or UDFs.please share some knowledgethanks in adv...
325 Jan 2008 @ 12:57 PSTDatabaseReplyOracle to Teradata Migrationlog table is obviously an option,and it can be exported by bteq export to a data file.But I am trying to use the external procedure feature to write the same UTIL_FILE pack in Teradata .
224 Jan 2008 @ 05:21 PSTDatabaseTopicOracle to Teradata MigrationThis bit of code is part of a procedure Which is written in Oracle environment..I haven't tested yet it in Teradata as it is pre-IT stage.But I think It will work in teradata environment also becau...
118 Jan 2008 @ 04:59 PSTConnectivityTopicHow to write UDF to handle operating System I/O operationsHi Can anyone please guide me writing fopen(),put_line() and fclose() UDFs in Teradata.These functions are in ORACLE UTL_FILE package.As database is migrating from oracle to teradata,I need to re...

Pages