1550 - 1600 of 2401 tags for Tools

We are beginning an effort to eliminate one of our DB2 Subsystems by redirecting the programs and plans to Teradata through the use of the FICON channel connect hardware/software. Does anyone have an experience with doing this? I'd be interested in hearing your results and what challenges you encountered along the way.

Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.

Hello all,I am new to TD . However with my background in Oracle , i have written a procedure .I was wondering if someone coudl tell me certain aspect in coding this procedure ,Here is the procedure,emp_check is a volatile table. Since I wanted to store the results and return them in the form of a table , i perform an insert operation in the volatile table.create procedure parameter_rolldown (IN dpt_id varchar(25) )BEGINDECLARE emp_count INTEGER;DECLARE emp_val VARCHAR(25);DECLARE emp_prior INTEGER;DECLARE Cur0 CURSOR FORSELECT min(emp_priority) from EMP_HIERARCHY;DECLARE Cur1 CURSOR FORSELECT emp_nm , emp_priority FROM EMP_HIERARCHY order by emp_priority;open Cur0;open Cur1;FETCH CUR0 into emp_count;FETCH CUR1 into emp_val, emp_prior ;insert into emp_checkselect * from ((QUERY1)UNION(select emp_id from emp_check) )main1;delete emp_prior, emp_val where emp_prior = 1; -- This I am doign because I want to move to the next recordselect (emp_count+1) into emp_count; while (emp_count>= 2 && emp_count <= 32) & & emp_prior = emp_countLOOP insert into emp_checkselect * from (QUERY) ABCINTERSECT(select emp_id from emp_check) )main2;delete emp_prior & emp_val where emp_prior = emp_count; (** I want to move to the next record in Cur1 , which will have record 2 .. I dont know how this can be done in TD .. Is there a syntax for NEXT ? **)select (emp_count+1) into emp_count; -- incrementing the counter to move to the next record in loop END LOOP;end while;end Cur1;end Cur0;END;I have one more question ..If I have to use the variables in a query in the procedure , Can i do the following,select * from employee where emp_id = emp_prior ..More commonly , how can i use the vaiables declared in the cursor...Do I need to use a identifier like % to distingush the vaiable from the table columns ?Also how can I use the input variable declared for the procedure in a query ?Can i do the following,select * from department where dept_id = dpt_idThank you already .... :)Thank you ,az_maverick

Hi,we run Teradata utilities both through UNIX and Mainframes.Can anybody please tell me in which scenario UNIX is preferable and when can we use mainframes to increase performanceThank You

Could you help me with finding an easy solution for exporting the information (model and data) from the Teradata MDS Repository for analysis purposes (without using the API or trying to query the backend MDS database)?

How do i generate a error ,when a set of records ina query do not intersect a set of records in another query.For eg,if I have a query ,select A,b from ABC INTERSECT select B,d from XYZI want to display all records in ABC which do not intersect the b,d in XYZ. What logic do I use ?Thank you,az_maverick

Hello all, I am trying to code a cursor/procedure as follows, I have a set of queries . The queries differ only by a single variable value.An example would be ..select * from ABC where X = 'Y' & U = 'V'select * from ABC where X = 'Y' & U = 'M'The variable U is a column in another table , which I will join in the cursor.At the moment my query loosk like ,select * from ABC where X = 'Y' & U = 'V'INTERSECT ( select * from ABC where X = 'Y' & U = 'M' INTERSECT ( select * from ABC where X = 'Y' & U = 'N' ))I want to do this intersection 'n' number of times , until all distinct values of the column 'U' have been tested .For this I plan to use a cursor/ procedure.However , i am finding it difficult to implement the query .Any suggestions...Regards,az_maverick

I am trying to run a FastExport script in which data is extracted from the table using the WHERE clause. Now in the WHERE clause there is a VARCHAR column. For extraction I have defined the fields in the LAYOUT using FIELDS and FILLER. Like, in the Teradata Database table there is a VARCHAR (128) column ACCOUNT_NAME which I am using in the WHERE clause. I am giving 6 characters in the input file and the remaining are spaces. So I define this in the LAYOUT as follows:.LAYOUT Account_input;.FIELD Accountnme VARCHAR(6);.FILLER Restskip VARCHAR(122);And the Select statement is as follow:SELECT * FROM TDUSER.ACCOUNTS;WHERE ACCOUNT_NAME = :Accountnme;The script is running fine with return code 0. But I don't find any output though 1 row should be selected as per the input that I am giving.So I was thinking that may be in my WHERE clause I need to mention the FILLER variable also, but I don’t know how to use it.If you have any idea about the same can you please help me out?

Hi All Teradata gurus!!Need help regarding FAST EXPORT utility failure.Below are the log file contents:0003 .LOGTABLE ;**** 08:20:22 UTY8400 Teradata Database Release: V2R.06.02.02.66**** 08:20:22 UTY8400 Teradata Database Version: 06.02.02.64**** 08:20:22 UTY8400 Default character set: ASCII **** 08:20:22 UTY8400 Current RDBMS has UDT support**** 08:20:22 UTY8400 Current RDBMS has Large Decimal support**** 08:20:22 UTY8400 Maximum supported buffer size: 1M**** 08:20:22 UTY8400 Data Encryption supported by RDBMS server**** 08:20:23 UTY6211 A successful connect was made to the RDBMS.**** 08:20:23 UTY6210 Logtable ' ' indicates that a restart is in progress.0004 .BEGIN EXPORT SESSIONS 8;0005 .EXPORT Outfile MODE RECORD FORMAT TEXT ;0006 ;0007 .END EXPORT ; ======================================================================== = = = FastExport Initial Phase = = = ========================================================================**** 08:20:23 UTY8700 Options in effect for this FastExport task: . Sessions: 8 session(s). . Mode: RECORD . Blocksize: 64260 bytes. . Outlimit: No limit in effect.**** 08:20:23 UTY8715 FastExport is submitting the following request: Select NULL from where (LogType = 220) and (Seq = 1) and (FExptSeq = 0);**** 08:20:23 UTY8713 RDBMS failure, 5628: Column FExptSeq not found in . ======================================================================== = = = Logoff/Disconnect = = = ========================================================================**** 08:20:23 UTY1005 Script file has been altered at line 1 prior to restart.**** 08:20:23 UTY6215 The restart log table has NOT been dropped.**** 08:20:23 UTY1009 RDBMS warning: 0, **** 08:20:23 UTY1009 RDBMS warning: 0, **** 08:20:23 UTY2410 Total processor time used = '0.036678 Seconds' . Start : 08:20:22 - WED MAR 25, 2009 . End : 08:20:23 - WED MAR 25, 2009 . Highest return code encountered = '12'.------------------------------------------------------------------------------------------Above details show that the LOG TABLE has not been dropped. But the LOG TABLE doesn't exist in the database where it is supposed to be created. I am unable to trace out the issue. Kindly help!!Thanks in advance,Sanjay.

Hi friends,i have a timestamp datatype on DOB column. but i want to take time only i dont want date..how can i do that ? pls anyone help me MURALI

Hi ,I need to generate a sequence in bteq, can any body tell me how to to do that?Thanks and Regards,Kapil

Hi friends, If i am getting data like oracle,that data want to load teradata database directly through utilities.Is there any posibility? how do i do that?pls help me......

hi, what are the difference between Group by and distinct

Hi friends, how referential integrity handled in teradata?

hi friends, what are the differences between delete and delete all?

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

Fastload is rejecting my attempts to load a timestamp column with the Invalid Timestamp Error 6760. I am attempt to load data like this:20010429 04:07:55.940000with this statement in the DDL part of my fastload, CHN_TS TIMESTAMP(6) FORMAT 'YYYYMMDDBHH:MI:SS.S(F)'with this defining my flat file field,CHN_TS (varchar(255))When I attempt a cast using the data there is no probleme.g. select cast ('20010429 04:07:55.940000' as timestamp(6) format 'YYYYMMDDBHH:MI:SS.S(F)')Your advice on how to overcome this would be very gratefully received. The flat file has come from Oracle in the first place and I can modify the format of the soure data. I am running fastload in Unix.Thanks,Susan

Trying to restore journal from backup but restore fails with following error*** Failure 2852:Inconsistent check point records found on Restored journal. Request you to share your thoughts or did ever anyone got this error and what was workaroundThanks in advance

Hi,Which utility is faster Mload or Fastload if we are loading data into an empty table and why?Can we load duplicates into a multiset table with a NUPI using Mload?Thank You

What will happen if we collect statistics on an empty table?Do we face any complexities because of this?

Hi,In our current project we are using Informatica and Teradata.All the operations done in Informatica can be done by Teradata SQL also.So can anybody tell me in which scenarios Informatica is better than Teradata?

I have installed the Teradata Express 12.0 in my PC for R&D purpose. I have executed the FastExport utiliy. I wanted to Xport the data to Windows notepad. The Utility is working fine, it is fetching the correct number of records from the Teradata Database but the BYTE data from the Teradata to the notepad is in unreadable format. I ran the utility with the default Character Set specification - ASCII and also executed the same by setting the Character Set specification to UTF8. But still the data in the notepad is in unreadable format. I am not getting the BYTE data in Teradata Database in a readable format in the notepad. I hve come across the UDF --> udf_toChar_mk183200 to convert BYTE to VARCHAR but dont know how to use it in the FastExport Job script. Can anyone tell me how to go about it.RegardsTorai

Hi - I need to generate a flat file using fastexport for Informatica to read.Teradata ---> Using fexp - Flat File ---> SQL SERVER load using Informatica.I need a fixed width or comma separated file.What should be the format of my fasexport script ?MODE RECORD FORMAT ? ; ?

DELETE FROM Employee WHERE Term_date > (subquery)

HI I am getting the following error while connecting to Teradata from Java using Type 4 driver,here intresting thing is the same program working in the same environment as a standalone but when ever tried to run in application , we are getting the following error. Our application like a batch process application it is not running on any application server.Please help me2009-03-13 18-27-53.636:UPDTESVC:SEVERE:winbackpapp1:lvoserver0:9070:com.convergys.lvo.server.framework.messaging.socket.SocketEventAdapter$1:run():232:"accept of socket failed, msg=Address already in use"Exception in thread "main" java.lang.StackOverflowErrorat java.nio.MappedByteBuffer. (MappedByteBuffer.java:69)at java.nio.DirectByteBuffer. (DirectByteBuffer.java:151)at java.nio.DirectByteBuffer.slice(DirectByteBuffer.java:169)at java.util.zip.ZipFile$MappedZipFileInputStream. (ZipFile.java:632)at java.util.zip.ZipFile.getInputStream(ZipFile.java:307)at java.util.zip.ZipFile.getInputStream(ZipFile.java:287)at java.util.jar.JarFile.getInputStream(JarFile.java:393)at sun.misc.URLClassPath$JarLoader$1.getInputStream(URLClassPath.java:620)at sun.misc.Resource.cachedInputStream(Resource.java:58)at sun.misc.Resource.getByteBuffer(Resource.java:113)at java.net.URLClassLoader.defineClass(URLClassLoader.java:249)at java.net.URLClassLoader.access$100(URLClassLoader.java:56)at java.net.URLClassLoader$1.run(URLClassLoader.java:195)at java.security.AccessController.doPrivileged(Native Method)at java.net.URLClassLoader.findClass(URLClassLoader.java:188)at java.lang.ClassLoader.loadClass(ClassLoader.java:306)at java.lang.ClassLoader.loadClass(ClassLoader.java:251)at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)at java.lang.ClassLoader.defineClass1(Native Method)at java.lang.ClassLoader.defineClass(ClassLoader.java:620)at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)at java.net.URLClassLoader.access$100(URLClassLoader.java:56)at java.net.URLClassLoader$1.run(URLClassLoader.java:195)at java.security.AccessController.doPrivileged(Native Method)at java.net.URLClassLoader.findClass(URLClassLoader.java:188)at java.lang.ClassLoader.loadClass(ClassLoader.java:306)at java.lang.ClassLoader.loadClass(ClassLoader.java:251)at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)at java.lang.ClassLoader.defineClass1(Native Method)at java.lang.ClassLoader.defineClass(ClassLoader.java:620)at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)at java.net.URLClassLoader.access$100(URLClassLoader.java:56)at java.net.URLClassLoader$1.run(URLClassLoader.java:195)at java.security.AccessController.doPrivileged(Native Method)at java.net.URLClassLoader.findClass(URLClassLoader.java:188)at java.lang.ClassLoader.loadClass(ClassLoader.java:306)at java.lang.ClassLoader.loadClass(ClassLoader.java:251)at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)at java.lang.ClassLoader.defineClass1(Native Method)at java.lang.ClassLoader.defineClass(ClassLoader.java:620)at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)at java.net.URLClassLoader.access$100(URLClassLoader.java:56)at java.net.URLClassLoader$1.run(URLClassLoader.java:195)at java.security.AccessController.doPrivileged(Native Method)at java.net.URLClassLoader.findClass(URLClassLoader.java:188)at java.lang.ClassLoader.loadClass(ClassLoader.java:306)at java.lang.ClassLoader.loadClass(ClassLoader.java:251)at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)at org.bouncycastle.asn1.nist.NISTObjectIdentifiers. (Unknown Source)at org.bouncycastle.jce.provider.symmetric.AESMappings. (Unknown Source)at org.bouncycastle.jce.provider.BouncyCastleProvider. (Unknown Source)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)at java.lang.reflect.Constructor.newInstance(Constructor.java:494)at java.lang.Class.newInstance0(Class.java:350)at java.lang.Class.newInstance(Class.java:303)at sun.security.jca.ProviderConfig$3.run(ProviderConfig.java:240)at java.security.AccessController.doPrivileged(Native Method)at sun.security.jca.ProviderConfig.doLoadProvider(ProviderConfig.java:225)at sun.security.jca.ProviderConfig.getProvider(ProviderConfig.java:205)at sun.security.jca.ProviderList.loadAll(ProviderList.java:254)at sun.security.jca.ProviderList.removeInvalid(ProviderList.java:271)at sun.security.jca.Providers.getFullProviderList(Providers.java:158)at java.security.Security.getProviders(Security.java:422)at sun.security.jgss.ProviderList. (ProviderList.java:116)at sun.security.jgss.GSSManagerImpl. (GSSManagerImpl.java:28)at org.ietf.jgss.GSSManager.getInstance(GSSManager.java:130)at com.teradata.tdgss.jgssp2gss.SspiMechanism. (DashoA1*..)at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)at java.lang.reflect.Constructor.newInstance(Constructor.java:494)at java.lang.Class.newInstance0(Class.java:350)at java.lang.Class.newInstance(Class.java:303)at com.teradata.tdgss.jtdgss.TdgssManager.createObject(DashoA1*..)at com.teradata.tdgss.jtdgss.TdgssManager. (DashoA1*..)at com.teradata.tdgss.jtdgss.TdgssManager.getInstance(DashoA1*..)at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM(GenericTeraEncrypt.java:583)at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:601)at com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:694)at com.teradata.jdbc.AuthMechanism. (AuthMechanism.java:50)at com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)at com.teradata.jdbc.jdbc_4.TDSession. (TDSession.java:194)at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection. (TeraLocalConnection.java:94)at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:55)at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:216)at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:149)at java.sql.DriverManager.getConnection(DriverManager.java:525)at java.sql.DriverManager.getConnection(DriverManager.java:171)at com.convergys.tks.util.TKSConnectionPool.addConnection(TKSConnectionPool.java:161)at com.convergys.tks.util.TKSConnectionPool. (TKSConnectionPool.java:60)at com.convergys.tks.util.TKS_DAO.buildSources(TKS_DAO.java:99)at com.convergys.tks.util.TKS_DAO.init(TKS_DAO.java:44)at com.convergys.tks.plugins.bo.DailyBOCacheMiss.init(DailyBOCacheMiss.java:139)at com.convergys.lvo.server.manager.LVOManagerNode.initializeManagedPlugins(LVOManagerNode.java:607)at com.convergys.lvo.server.manager.LVOManagerNode.initialize(LVOManagerNode.java:579)at com.convergys.lvo.server.manager.LVOManagerNode. (LVOManagerNode.java:303)at com.convergys.lvo.server.updatesvc.LVOUpdateSvc. (LVOUpdateSvc.java:454)at com.convergys.lvo.server.updatesvc.LVOUpdateSvcAgent. (LVOUpdateSvcAgent.java:68)at com.convergys.lvo.server.updatesvc.LVOUpdateSvcAgent.main(LVOUpdateSvcAgent.java:102)

FYII found a slipperly SQL asssistant feature. I've just logged this with Terdata feedback, but not sure if it was the correct channel to log a software bug.Basically if you use Teradata SQL Assistant (QueryMan) I'd recommend *not* enabling the option to use multiple queries in a single session (menu -> tools -> options -> allow multiple queries). This option is evil :)It works fine to open multiple SQL queries, but the danger is later saving them. The default name for *all* of the multiple queries is the most recently opened or saved name. If you open thre sql queries, when you come to save them, each one will be saved with the name of the most recent query. Therefore your are likely to overwrite queries and lose work.You've been warned!!!CheersTim

I loaded Teradata demo on my sys. I want to open BTEQ but It was asking for login/password. Can know where i can find them. I didnt gave any username or password while i installed.

Hi,Can someone pls tell me how to skip the header row in the flat file, when importing using FastLoad script on Unix.ThanksNick --

I have a java program which connects to Teradata and backs up data into a local MS Access database. After installing TTU 12 it stopped working saying :java.sql.SQLException: [Microsoft][ODBC Driver Manager]UnknownThis was while accessing MS Access, not Teradata. This has happened across all systems which installed TTU 12.I thought maybe the problem lies in the ODBC setup. I was using a DSN-less connection so far to avoid having to setup User DSNs etc in various systems & with limited registry access :{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");String database ="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};DBQ=c:/db2.mdb;DriverID=22;READONLY=true}";Connection con = DriverManager.getConnection( database ,"","");Statement st=con.createStatement();ResultSet rs=st.executeQuery("select * from login" );}So now I created an ODBC source and connected through that like this:String url = "jdbc:odbc:wombat";Connection con = DriverManager.getConnection(url, "oboy", "12Java");But still the same error occurs. When I opened up MS Access and tried to access the tables I got a single error dialog box with the single word : Unknown ...this is what is passed to the driver as well & appears in my Java SQL Exception. Now I know it appears to be a Java issue and having nothing to do with Teradata, but this has happened on 20 systems on the same day exactly after TTU 12 was installed and on widely separate geographic locations.All had Windows XP SP2 - 32 bitFurthermore the MS Access database was in Access 2000 version so I changed it to 2002-2003 version and tried again but got the same error : Unknown when I clicked to open any tables. Now MS Access 2003 can't open its own tables!! Then I tried this on a system with Office 2007 in it, and it works ! and JDBC too, so TTU 12 has not affected systems having Office 2007.My conclusion is that TTU 12 in some way broke the ODBC setup and affected MS Access settings even though there is no way it should. Can someone please make sense of all this as I have Office 2003 in my system and we are not upgrading to Office 2007. But I really need to access the tables in this database. How come this was not caught during testing ?..and please dont tell me to download the Office compatibility pack..TTU 12 is not supposed to even touch MS Office in any way !This has been posted before and no attempt was made to resolve it:http://www.teradata.com/teradataforum/Topic13050-10-1.aspx?Highlight=ms+access

Hi , I am getting the following error when doing a fast load.**** 15:21:00 RDBMS error 2635: Error tables are invalid OR TFL_SALE is in an invalid state for Loaddoes this mean the is a fastload lock on the table.Need help in solving this...Thanks Nick

I am being told by my teradata team that since they do not use LDAP they cannot make use of the security features of TDGSS Libarary, is this true?Does TDGSS has any dependencies?I read somewhere that TDGSS works for only network-attached clients and not for channel attached clients?what is the difference between the two?I know our team is using TD2 mechan

I am on a Windows XP system. When I run fastload like thisfastload < loadcmd.flit works correctly. When I try to run it and redirect the output file fastload < loadcmd.fl > loadcmd.logorfastload < loadcmd.fl > loadcmd.log 2>&1I get a null reference error from Windows. The error is The instruction at "0x00000000" referenced memory at "0x00000000". the memory co9uld not be "read".Anyone seen this type of error before? I am running fastload version 12.00.00.004.R

Hi. Due to the size of my history database and the number of connections I have, I decided to switch to using a separate history database for each connection type. I have no issues with SQL Assistant creating the history databases for any of my connections - with the exception of Merrant Tracker SQL Server databases. For some reason - these history databases do not get created as an Access database in my common folders. However - the history is being tracked. Each query I've run appears in the history pane. I'm simply trying to find where it's being stored. I've tried running a scan of all connected drives to my PC for any *.mdb files, but nothing appears that would be a history database for this specific connection. Does anyone else have this issue and/or does anyone have any suggestions as to where this history might be stored?Thanks,John

We recently upgraded several Windows servers to V12 of the Teradata Utilities as part of a hardware upgrade. The odd thing is that we have been able to successfully run utility jobs (FastExport, FastLoad, MultiLoad) on these servers without actually setting up an ODBC data source that points to our new Teradata database machine.The same thing has occurred on Linux servers we have upgraded. We have built test DataStage apps that extract from or load to the new Teradata machine - but we have not added any new entries to the Linux hosts file - we just run the DS job and, somehow, it connects correctly.I hate to go looking for trouble when something is working, but we are genuinely puzzled as to why it's working. How are the Teradata Utilities able to find and connect to this otherwise unknown machine?Any and all help is appreciated!

Hi, I'm using bteq to export data into a csv file for opening in ms excel.I need the selected data, along with the title of the data to show up in the excel file, however, the long title makes the size of the first column long, thus opening the excel file does not show the data in the first row (unless you double-click the edge of the row, so that the entire width of the cell will expand. Is there a way to format this such that I will still be able to see the first row upon opening the file?Here is my command:LOGON_STRING=`cat logon/bteq`bteq <<- EOF.LOGON ${LOGON_STRING};.SET TITLEDASHES OFF;.SET SEPARATOR ',';.EXPORT file=/mydir/test_file.csv.SET RTITLE "THIS IS THE TITLE OF THIS CSV FILE WE ARE EXPORTING FROM THE DATABASE";.SET FORMAT ON;SELECTtest_id (CHAR(8)) (TITLE 'TEST'),test_cd (TITLE 'CODE')from database.table;.SET FORMAT OFF;.EXPORT RESET.LOGOFFThe result is this: (When this is viewed in excel, the first column values under test is not visible since the size of the column is small, and the width of the title's column is large. Also, even if i set the length of TEST to be only 8Chars long, the column automatically adds extra character before the values.09/03/04 THIS IS THE TITLE OF THIS CSV FILE WE ARE EXPORTING FROM THE DATABASE Page 1 (this has blank spaces)TEST CODE(this has blank spaces)TF999003 TCLSOH65DS1(this has blank spaces)TF999002 TCMTOH3333E(this has blank spaces)TF999006 TCHGMIMNDS1(this has blank spaces)TF999005 TCWOTXPEAXD(this has blank spaces)TF999004 TCRTMIMTDS0In the unix .csv file, it shows up as:09/03/04 THIS IS THE TITLE OF THIS CSV FILE WE ARE EXPORTING FROM THE DATABASE Page 1(this has blank spaces)TEST ,CODE(this has blank spaces)TF999003,TCLSOH65DS1(this has blank spaces)TF999002,TCMTOH3333E(this has blank spaces)TF999006,TCHGMIMNDS1(this has blank spaces)TF999005,TCWOTXPEAXD(this has blank spaces)TF999004,TCRTMIMTDS0Any idea how i can remove the excess spaces before the first column's values?Thanks!

hi all can anybdoy tell me what is purpose of .export reset in bteqi know the bookish one but,i am not satisfied with that one

hi all can anybdoy tell me what is purpose of .export reset in bteqi know the bookish one but,i am not satisfied with that one

HiI have some doubts over integer formats...I created 3 tables and ran similar set of queries1)create table table1(a integer format '-(10)9')insert into table1 values(123456)sel a (char(6)) from table1;output=12)create table table2(a integer format '-9(10)')insert into table2 values(123456)sel a (char(6)) from table2;output=000013)create table table3(a integer format '(10)9')insert into table3 values(123456)sel a (char(6)) from table3;output=000012I am not able to understand why different outputs are comingand more precisely how signed/unsigned is handled here...also what is the differenece between '-9(10)' & '-(10)9'

Hello,I'd like to know how to expand the partitioning of an Aggregate Join Index.Thanks in advance

The error info :429: The monitor object(TDMon5.dll) is missing, or is not correctly registered.

Hi,Multiload will automatically creates Error table while loading from file to database. Is there any way to generate error files on unix box instep of error tables. Please help me in this case.Thank you,Regards,Kiran

Hi,I am getting below error while inserting data into table ** Error: Import data size does not agree with byte length. The cause may be: 1) IMPORT DATA vs. IMPORT REPORT 2) incorrect incoming data 3) import file has reached end-of-file.I am importing data from below file:cat /home/user/jjxyz 1abc 2BTEQ Script as below:.logon xyz/loginid,password.IMPORT DATA FILE = /home/user/jj,SKIP = 2.QUIET ON.REPEAT *USING NAME(VARCHAR(25)),ID(INTEGER)INSERT INTO DB.TABLE(NAME,ID)VALUES(:NAME,:ID);COMMIT;.LOGOFF..QUITMy table defination as:CREATE SET TABLE DB.TABLE,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( NAME VARCHAR(25) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'MANAGER_NAME' NOT NULL, ID INTEGER)PRIMARY INDEX ( ID );Please help me out of this.Thanks a lot.Regards,Ravi.

HiCan anybody tell me what we need to do when we are exporting1)integer2)character3)date to IBM environment(as client)..I am getting junk characters...Can anyone tell what kind of rules we need to follow when client is IBM and windows...while fast exporting the file

Hi,We have defined a workload as having classifications of < 1 Sec CPU Time and 'Include Single or Few Amp Queries Only' .Does anybody know if there is a definition of 'Few Amps' that is used ?

Hi ,I have a file with header, data racords and trailer. Data record is delimited with comma and header and trailer are fixed width.The header and trailer starts with (HDR,TRA). I need to avoid the header and trailer while loading the file with Multiload. Please help me in this case.Thank you,Regards,Kiran

Hi All,We have a requirement wherein Customer who has made purchases of at least $ 10000 in a 6 month period and made atleast a single visit a month in a 6 consecutive month period should be given a rating of A+B+. and Customer who has made purchases of at least $ 10000 in a 6 month period but not made atleast a single visit a month in a in a 6 consecutive month period should be given a rating of A+B-. sample data CUSTOMER_ID PURCHASE_DATE PURCHASE_AMOUNT101 02-MAR-07 10000101 02-APR-07 8000 101 05-MAY-07 10000 105 18-JAN-08 10000101 18-FEB-08 5000102 18-MAR-08 20000103 18-APR-08 3000102 23-MAY-08 2000104 02-JUN-08 10000103 02-JUN-08 30000101 02-JAN-08 51000With this kind of data we need to write a query to retrieve only those customers who have data in each of the last six months, like in this example it should be customer number '101'.Customer '103' should be ignored as it does not have data for last six months CONSECUTIVELYThanks & Regards,Praveen

Hi All, I need to estimate the Multiload, FastLoad, and BTEQ scripts in project. Can any body tell me that which which things will consider in complexity of each Multi load, Fastload, and BTEQ jobs.... and the time for each activity..Thanks in advance