#DateForumTypeThreadPost
1822 Aug 2008 @ 09:19 PDTToolsTopicFailure 3738: String is longer than 31000 charactersHi,I am trying to insert a string of length approx 32000 into a table with the definition as shown below:Request TextCREATE SET TABLE file_storage ,FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL,CHEC...
1722 Aug 2008 @ 09:18 PDTDatabaseTopicError 3738 String is longer than 31000 charactersHi,I am trying to insert a string of length approx 32000 into a table with the definition as shown below: Request Text CREATE SET TABLE file_storage ,FALLBACK , NO BEFORE JOURNAL, NO AFTE...
1609 Jul 2007 @ 08:10 PDTToolsTopicMLOAD LayoutHi,Is the Layout statement mandatory in the mload script?My Script without the layout and the layout option in the import statement:.LOGTABLE abc;.LOGON sname/uname,pwd;.BEGIN IMPORT MLOAD TABLES t...
1519 Feb 2007 @ 04:11 PSTToolsTopicfload errorHi,These are my fast export and fast load sripts which I am trying to use to load from one table to the other. The definition of the source table was copied to create the target table. But still I ...
1419 Feb 2007 @ 12:53 PSTDatabaseReplyfastload error:I tried this but its still giving me the same error.In the load script i am using set record formatted.Is that the right way?
1318 Feb 2007 @ 11:13 PSTDatabaseTopicfastload error:Hi,These are my fast export and fast load sripts which I am trying to use to load from one table to the other. The definition of the source table was copied to create the target table. But still I ...
1215 Feb 2007 @ 07:18 PSTToolsTopicFload errorHi,I am using a script that uses the fexp and then fload. The script moves data from our production environ. to QA environment. I copied the ddl for a table from prod and created the table on QA en...
1114 Feb 2007 @ 04:14 PSTConnectivityReplyTrying to set up ODBC connectionThis helped me as well. Thanks guyz.
1010 Dec 2006 @ 05:27 PSTTrainingTopicNUPI and UPIWhen is NUPI preferred over UPI? and When is UPI preferred over NUPI?What are the advantages of one PI over the other?
908 Dec 2006 @ 04:58 PSTTrainingReplyIs it okay to post questions and their answers from a recent exam on this forumI guess ur right. Thanks.
808 Dec 2006 @ 01:43 PSTTrainingTopicIs it okay to post questions and their answers from a recent exam on this forumHi,One of my colleagues just gave his teradata basics exam. I was wondering if it is okay to post a few questions with the answers on this forum.Tariq.
710 Nov 2006 @ 12:58 PSTDatabaseReplyRDBMS failure in Macro Build: 3524, The user does not have CREATE MACRO access to database...Hi,Thanks for the reply.I don't know what DIP scripts are and its not a newly-initialized (sysinit) database.Can you please let me know?Thanks,Tariq.
609 Nov 2006 @ 03:53 PSTDatabaseTopicRDBMS failure in Macro Build: 3524, The user does not have CREATE MACRO access to database...Hi,I am getting the following error in fastload, does anyone have an idea why.RDBMS failure in Macro Build: 3524, The user does not have CREATE MACRO access to database...Thanks.
530 Oct 2006 @ 05:13 PSTDatabaseReplyConcatenating quotes to a variable/parameter value in an SQL queryAlright I have it now.The answer is to use it like thisselect '''' || 'tariq' || '''' from .........
430 Oct 2006 @ 02:05 PSTDatabaseTopicConcatenating quotes to a variable/parameter value in an SQL queryHi,This is my query:select 'tariq' from abc sample 1;result: tariqBut if I want my output with single quotes around it how do I do that?required result: 'tariq'I tried this but the following did no...
312 Oct 2006 @ 11:36 PDTToolsReplyTeradata export file contains junk charactersHi Daniel,Just removed the format part in the select statement and it worked. It returned the date with 8 leading spaces. Figuring a way to get rid of those in the select itself.Thanks for your help.
212 Oct 2006 @ 09:09 PDTToolsReplyTeradata export file contains junk charactersThanks Daniel, but I realized that there is more to the problem. Initially I had typed in the date value for testing but I realized that the date never got overwritten. Infact it stayed there and j...
111 Oct 2006 @ 08:28 PDTToolsTopicTeradata export file contains junk charactersHi,I have written the following code and I am expecting only a single date value..MAXERROR 1;.SET FORMAT ON.SET ECHOREQ OFF.EXPORT DATA FILE=${DW_OUT}/${JOB_ENV}/${SUBJECT_AREA}/lastunsuccdate.dat,...