#DateForumTypeThreadPost
54628 Jan 2014 @ 12:29 PSTDatabaseReplyUDF in teradataHow about these links? http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Load_and_Unload_Utilities/B035_2414_071A/2414ch03.014.26.html http://stackoverflow.com/questions/7718299/...
54528 Jan 2014 @ 12:02 PSTToolsReplyMload upsert - 6705 - SAP BW as source Error code 6705:Is an error in a string having Multi-byte characters. So you need to correct the SQL or data as Mload doc suggests.   Same like in all ETL tools, you should code a l...
54427 Jan 2014 @ 09:09 PSTDatabaseReplyGet query metadata without running itI am not able to understand clearly. However, let me try to answer. Is this what you are talking? show select * from DB1.raja_test----raja_test is a table. Cheers,  
54327 Jan 2014 @ 09:19 PSTDatabaseReplySelection of Primary indexI suggest you check  the data distribution properly. You have 50 columns. Else you may need to change later. You can go ahead with composite if you are using them too in access conditions. &...
54227 Jan 2014 @ 08:37 PSTDatabaseReplySelection of Primary index Guidelines for selecting PI are if you use most frequently in access or equality conditions. Dstinct values that distribute evenly across all amps to maximize parralelism. It is a column ...
54127 Jan 2014 @ 08:07 PSTToolsReplyLaunch BTEQ File from VBATo be honest, I have never used VB with Teradata. I had a direct configuration from excel with some programming. After connection , can you try with this logic: after logon........ .import...
54027 Jan 2014 @ 06:31 PSTDatabaseReplyDeadlocks whenusing Teradata with Informatica It could be due to many reasons because of PDO.Are  you using bteq, tpump etc? Are they insert,update etc.   How many batch ids are accessing the same resource? What are your v...
53927 Jan 2014 @ 04:06 PSTDatabaseReplyRANGE in INTEGER data fieldsNot able to understand your requirement. Can you please put in the same format as you put (WHEN.........'9')  and what you want in the same format. Cheers,
53827 Jan 2014 @ 12:39 PSTToolsReplyTeradata automation script I dont know whether it will help you or not.I do not have much experience in Mainframe. However, I can see that you are almost there. You can write script which accepts parameters( general) to l...
53727 Jan 2014 @ 12:16 PSTViewpointReplyMigrating to new Viewpoint server My thought:   Do you have configuration mgmt infrastructure in your project? Or Teradata also has MDS. Afaik,MDS can act like a code promotion tool too where you can port your codes...
53626 Jan 2014 @ 11:25 PSTDatabaseReplyMLPPI questionHi, You could have tested: CREATE MULTISET GLOBAL TEMPORARY TABLE DB1.raja_test1 ( claim_id INTEGER NOT NULL, cust_id INTEGER NOT NULL, claim_date DATE NOT NULL, city VARCHAR(3...
53526 Jan 2014 @ 10:52 PSTDatabaseReplyGenerate SurrogateKey with a huge table   So , yes it is the same concept we did. I think it is a better way to do this way,rather than using sequence or identity number. There may be smarter ways of doing, if someone can sha...
53425 Jan 2014 @ 09:10 PSTDatabaseReplyConnect VBA to Teradata Hi, In excel, there are some settings where you can configure and you can write query too . But my experience for large voulume of data it hangs.  Can you try with these examples given: htt...
53325 Jan 2014 @ 08:48 PSTConnectivityReplyUpgrade Client ODBC DriversI think downloads are here : http://downloads.teradata.com/download. Before installing, I think it is better to read readme docs. Cheers,
53225 Jan 2014 @ 08:04 PSTToolsReplyGetting an error: "6996: Invalid conversion or assignment operation on a Period." during MLOADJust for sharing information can you please, share the diff? Also with that diff maybe you can call informatica tool support folks to get it resolved. Just my suggestion. Cheers,
53125 Jan 2014 @ 07:56 PSTDatabaseReplyGenerate SurrogateKey with a huge table I used same method when loading from staging to target. I think you use staging too. Do you use? Please let me know. I feel that at any cost, you have to do it, one way or the other. My thou...
53025 Jan 2014 @ 07:50 PSTDatabaseReplySupporting Chineese charaters in TeradataTo be honest I dont know Chinese. But just to pitch in. I heard that there are Chinese Simplified and Chinese Traditional. So those different geometrical boxes maybe different.  Cheers,
52924 Jan 2014 @ 10:10 PSTDatabaseReplyOrder of sql execution in a macro I guess that teradata macros are intelligent enough to execute those statements that do not have /share dependencies in parallel. Cheers,
52824 Jan 2014 @ 08:23 PSTToolsReplyhow to execute batch command in SQL assistant? It is a good idea. However, I 've never encountered or I dont think it is possible. First execute an OS command then call the DML/DDL/DCL/TCL then outside it finally calling TCL. It ...
52724 Jan 2014 @ 04:52 PSTToolsReplyGetting an error: "6996: Invalid conversion or assignment operation on a Period." during MLOAD Whaw !!!! that sounds weird. Could you get the ctl file , created when you had used TD 13 and now when you upgraded to 14 and see the diff? Cheers,
52624 Jan 2014 @ 04:30 PSTToolsReplyGetting an error: "6996: Invalid conversion or assignment operation on a Period." during MLOADI think it happens with few tools. You can think of loading as char or varchar as normal process in a job. Then at the end you can run task, in a session calling a script or unix script to load fro...
52524 Jan 2014 @ 03:22 PSTToolsReplynew line characteroh! I wish all clients upgrade to 14.10 with all features. :)  
52424 Jan 2014 @ 03:19 PSTGeneralReplyfs-ldm and tsysProbably, there may be another route , where you can get info, by contacting the organizations directly. It is just my opinion. I used to work before with source from TSYS, but not using FSLDM. C...
52324 Jan 2014 @ 12:21 PSTDatabaseReplyFormatting CURRENT_TIMESTAMPIf you are particular about current_timestamp, you can think of : select cast((current_timestamp(FORMAT 'YYYYMMDD')) as char(8))||cast((current_timestamp(FORMAT 'HHMISS')) as char(...
52223 Jan 2014 @ 11:24 PSTDatabaseReplySQL Workaround You have not shared few more infos like    data volume, explain, amps etc if any. You can mask any business-critical stuffs :) . Are they the same tables as you mentioned a...

Pages