Teradata Forums / Teradata / Teradata Tools and Utilities

Can I rollback in ANSI mode without Transient Journel?

ravindrareddy — Fri, 06 Nov 2009 14:59:57 GMT

Can I rollback in ANSI mode without Transient Journel?I have a requirement to update a table...if the number of records which are updated is not matched with the intended number of records it should not commit to DB.Is there any way to accomplish this other than using ANSI mode/Transient Journal??Coz..ours is a very small system with 20 AMPS.

ANSI Mode BTEQ Script

ravindrareddy — Fri, 06 Nov 2009 11:18:34 GMT

Hi All,I need to write one Bteq script to update my table.Along with this I need to take the number of records it is going to update by running select statement before Update statement.Once update statement is complete..I want to see how many records this Update statement has updated...If the prior count and after counts are matching Commit this operation else through an error by releasing the lock and do a ROLLBACK.As per my knowledge I need to go for ANSI transaction mode...I'm very new in using ANSI mode in BTEQ...Could any one help me in providing sample BTEQ script for this scenario...Thanks In Advance Learn And Share...URSRavindra Red

passing parameters to mload

TD DEV — Thu, 05 Nov 2009 15:38:17 GMT

Hi guys,I donot know the syntax for passing parameter to mload. I am trying to pass two strings as parameter to mload script file and use these string parameters in the script.something like mload [TableName, SOURCEFILENAME] <Path of sourcefilename. Here is my scenario:This is the part of mload script where i want to use the passed string(in INSERT STAMENT below). In TestTable(Teradata table) , there is a column called stream which contains the source file name from which data is loaded into TestTable in Teradata.In this case the source file name is 'Caliente' which is entered manually in the insert statement below.There are many source files like these from which i need to extract data from and put the corresponding source file name in Stream column. So as first step i would like to pass the source file name as parameter to mload while calling the file that contains the script.INSERT INTO "TestTable " ( Dance_ID, Delete_Flag, Cat_ID, Non_Music, Mark_Status, Run_Time, Daypart, Add_Date, Add_Date_DATE, Add_Date_TIME, Del_Date, Del_Date_DATE, Del_Date_TIME, Cat_Plays, Lib_Plays, Old_Skips, Old_Fails, Perf_Count, Rot_Weight, Max_Daily, Old_Start, Old_Kill, Kill_Plays, Simulcast, Tag_Along, Packet_ID, Audio_Ptr, Master_Ptr, Edit_Date, Edit_Date_DATE, Edit_Date_TIME, Move_Date, Move_Date_DATE, Move_Date_TIME, Move_Cat, Start_Hour, Start_Hour_DATE, Start_Hour_TIME, Kill_Hour, Kill_Hour_DATE, Kill_Hour_TIME, Stream ) VALUES ( :Dance_ID, :Delete_Flag, :Cat_ID, :Non_Music, :Mark_Status, :Run_Time, :Daypart, :Add_Date, :Add_Date_DATE, :Add_Date_TIME, :Del_Date, :Del_Date_DATE, :Del_Date_TIME, :Cat_Plays, :Lib_Plays, :Old_Skips, :Old_Fails, :Perf_Count, :Rot_Weight, :Max_Daily, :Old_Start, :Old_Kill, :Kill_Plays, :Simulcast, :Tag_Along, :Packet_ID, :Audio_Ptr, :Master_Ptr, :Edit_Date, :Edit_Date_DATE, :Edit_Date_TIME, :Move_Date, :Move_Date_DATE, :Move_Date_TIME, :Move_Cat, :Start_Hour, :Start_Hour_DATE, :Start_Hour_TIME, :Kill_Hour, :Kill_Hour_DATE, :Kill_Hour_TIME, 'Caliente' ) ;The other string parameter should be used to specify the source file name in import infile statement. In this case:(see the code below)instead of C:\TD_ETL\ACEESS_ FILES_TEST\TestTable _Caliente.amj i should have C:\TD_ETL\ACEESS_ FILES_TEST\SOURCEFILENAME.amj where SOURCEFILENAME is other parameter passed in the mload. .IMPORT INFILE "C:\TD_ETL\ACEESS_ FILES_TEST\TestTable_Caliente.amj" AXSMOD Oledb_Axsmod 'noprompt' LAYOUT Layout1 APPLY LabelA ;Thanks in advance..

Teradata compatibility with new version of windows (windows 7)

jesu maria antony — Fri, 06 Nov 2009 10:22:34 GMT

hi,i installed the new version of windows (windows 7) . the version of teradata i tried to install was 12.1 . I am not able to install all teradata tools like sql assistant, administrator .etc .. ,. all the installations fail in windows 7 . Is there any way to sort this out ,,, can anyone help me out in this ???Thanks in advanceregards,Jesu

TPT And Mainframe Chanel Attached Systems

Ray Uranker — Thu, 05 Nov 2009 16:31:29 GMT

We have our production Teradata box connected to the production mainframe via a TDP channel. Our test Teradata box is connected to the test main frame via a different TDP channel.If I initiate a TPT job on the production mainframe, will the TPT script be able to copy data from the production Teradata box to the test Teradata box? Or will I need to run the TPT script on a platform that has access to both or does TPT really only use the TDP channel to get to Teradata and the rest is between the two Teradata boxes?

TPT Script Multiple Table Question

Ray Uranker — Thu, 05 Nov 2009 16:19:40 GMT

Lets say I have 10 tables in database ABC. I need to move the data in these 10 tables from our production box to our test box. The tables in production are on separate Teradata machine than the ones on test (teraprod vs teratest) but the tables themselves are exactly the same when it comes to fields and data types.I know I can create separate TPT scripts to move the data. My question is whether I can put all the script logic in a single JOB? I used the wizard to create a successful script, tried adding in another table and the script would no longer run (compilation error). Or am I forced to put each table in its own TPT script and execute each script.We are on v12.1 I did not find anything in the TPT user documentation.

In TPT UPSERT on a table with an Identity Column primary index is illegal

Umesh Goel — Wed, 04 Nov 2009 05:17:07 GMT

Hi While using TPT M getting below error message in upsert UPSERT on a table with an Identity Column primary index is illegalMy Query is like below : APPLY ( 'UPDATE EIWStageTB.CoorsPointInventoryChange SET SuspenseFlag = :SuspenseFlag WHERE DistributorCd = :DistributorCd (DECIMAL(18,0)) AND MaterialNo = :MaterialNo (DECIMAL(18,0)) AND SeqNbr = :SeqNbr (INTEGER) AND WeekNo = :WeekNo (DECIMAL(18,0)); ',

Teradata TPT Script

Ray Uranker — Wed, 04 Nov 2009 16:25:55 GMT

I am attempting to write a TPT script to move data from one table to another. The tables are on two different Teradata systems (one is production the other is test). My source and target table are exactly the same in every way (fields, datatypes,...). I was able to get the script to work no problem.Here is my question. Since the tables are exactly the same, does the script need to have DEFINE SCHEMA listing all the fields and data types? Sure would be nice not to have to define field level details. My ultimate goal is to create a dynamic TPT script moving a variable table list and it would be sure nice not to have to go down to field level definitions.

Database Tree in Teradata SQL Assistant 12.0

peterg — Fri, 30 Oct 2009 00:54:52 GMT

Hopefully a simple question - although trying to find an answer has been anything but!Using Teradata SQL Assistant 12.0 on Windows XP Service Pack 3Have many databases listed in my Database Tree accessing the many different areas of our Teradata DW.Changing laptops, appears I have to re-add these Databases every time.Simple question:Where is this list of Databases stored on my current laptop - they appear to be unique to my username on this device?Appreciate your consideration - Thanks in advance

How to search through multiple stored procedures?

ratu — Wed, 28 Oct 2009 14:17:13 GMT

Hi All,I am trying to search for dependencies in our database, and I have about 500 stored procedures to go through. Is there an easy way to do this?I compiled all the show procedures as follows:SHOW PROCEDURE database_name.procedure_name_1;SHOW PROCEDURE database_name.procedure_name_2;SHOW PROCEDURE database_name.procedure_name_3;SHOW PROCEDURE database_name.procedure_name_4;SHOW PROCEDURE database_name.procedure_name_5;etcDoes anyone know how I can save the result set into a table or export it to a text file where I can perform my searches on the keywords?Thanks!

MLoad Question

Greyghost — Tue, 27 Oct 2009 09:45:08 GMT

Can someone explain this, since I don't understand what is happening. My MLoad runs to a good completion code. However, my question is about the number of records read in, compared to the number inserted. Records read = Records that satisfy the conditions. However, the records inserted does not equal these numbers. Why? There are no UV or ET records written, so I am confused why the number inserted is not the same as the records that satisfied conditions.Here are the stats from the log file: . IMPORT 1 Total thus far . ========= ============== Candidate records considered:........4662284....... 4662284 Apply conditions satisfied:.......... 4662284....... 4662284 Candidate records not applied:....... 0....... 0 Candidate records rejected:.......... 0....... 0----------------------------------------------------------------------------------------------- Inserts: 4624210 Updates: 0 Deletes: 0 ============== ======================================================== 0 TDWWorkTbls.ET_IMFStage 0 TDWWorkTbls.UV_IMFStageThanks!Paul

How to Convert VARCHAR(30) to a DATE in Fastload

JB — Thu, 03 Sep 2009 18:22:43 GMT

I have a table coming in from Sybase using BCP. It is pipe delimited. There is a Date field I will call RecordDate. It is Varchar (30) but it needs to be a DATE so that it can be compared to another table using the date and some other fields. I tried several ways to format the fastload program to bring in and format a DATE instead of a VARCHAR(30) but the program will only work if I bring it in as a varchar (30). I looked at the input file and it is pipe delimited, but in the varchar(30) field, I only see something like this: 12/31/2008 I am a supervisor and have been hands off for awhile, but we are short handed and I'd like to get this working. Any suggestions? Please? Thanks.

Import in TD SQL Assistant

Nisith Bhattacharya — Mon, 27 Aug 2007 18:30:42 GMT

Hi All,
I have exported a table to a file using the export facility of SQL Assistant.
The export was successful and the file was created.
Please help me to import the file.
Thanks.

query does not complete -- but no error message

alandool — Thu, 22 Oct 2009 12:07:11 GMT

Hello All,I have a query that has 11 steps in it where it creates several volatile tables in Teradata SQL Assistant. For some reason it stops after the fourth step and gives no error message, etc. I can then highlight and run the additional steps without problem. I need it to run straight through. Any ideas why this may happen?Alan

Insufficient memory to parse request during Optimizer phase.

Toshu — Mon, 08 Jun 2009 02:06:24 GMT

Hello,i'm running BTEQ via MVS Batch (BTQMAIN program).From yesterday, i'm getting below error for my SQL:Failure 3710 Insufficient memory to parse this request, during Optimizer phase. Statement# 1, Info =0 I figured out that it has something to do with MaxParseTreeSegs. But don't know how to use it in my case. I don't have much access to teradata which is behind the seen.Is there any way to tackle this issue. May be by including some statement at the top of my SQL query?Please suggest!Thanks,Tushar Saxena

mload upload of csv file with Comma ',' and ""

amonadi@hotmail.com — Wed, 21 Oct 2009 17:54:35 GMT

Hi,I would like to know if there is any way to load csv files with mload when they contain quotations. Excel places quotations marks around cells that have "" commas as cell value.I know in Oracle there is and Optional tag in the control file to indicate data file may also be enclosed in double quotes. Is there such a think for Teradata Mload?I am aware of the option to save the file as Tab Delimited and then replace Tabs with "" but was hoping for a better solution than this.Thanks,

MLoad Update

DAZZLER — Tue, 20 Oct 2009 09:59:33 GMT

I have to Update only one field in the table with one valuea using MultiLoad (dont want to use BTEQ since DBA dislike to update table with >100k rows with BTEQ). For instance, SQL is following...Update DB.TABLE1SET FIELD1=703WHERE FIELD1=1;Now, i have done updates usnig field input, but never with one colum value. Do i have to treate this as file input and change SQL as below or is there any other way of doign it?Update DB.TABLE1SET FIELD1=:FIELD1WHERE FIELD1=1;

I am unable to load data using SQL Assistance

kiran_terydata — Thu, 10 Sep 2009 02:06:50 GMT

Hi FriendsI am unable to load the data when inserting nulls or strings in the table using QUERY MAN.insert into fact_current values(id, name, ,"expected",salary);Wat is the problem?Please tell me the solution.KIRANkiran_teradata@ymail.com

mload error 3524

yujing — Fri, 16 Oct 2009 10:32:13 GMT

We have a scheduled Teradata job runs everyday and works fine. Recently, this job failed with error code 3524, the user does not have CREATE TABLE access to database XXX ( our database name). I know that is not correct since it has run a while and nothing has been changed. We rerun the job using the same user after it failed; it ran successfully without any scripts changes. Have you met this problem before? We are on Teradata version 12. Really appreciate your input. Best Regards

Fast Export & Fast loading

Gurunathan — Tue, 13 Oct 2009 03:05:40 GMT

HiIn UNIX, I have fast exported 10 rows from source table(2 columns--item_id, site_id) to dw_abc(text format). For eg: .export outfile dw_abc format text; ** this is the syntax i have used.-------10 rows got exported, but the problem is when i was opened the output file "dw_abc" in UNIX. It was showing like this.item_id site_id100 200300 400500 600700800 ------------- item_id, site_id were not separated900 1000101201-------------item_id, site_id were not separated301 401501601-------------item_id, site_id were not separated701 801901 1001Some of the item_id, site_id got separted by tab as a delimiter. Some item_id, site_id's were not separted. I want, all the item_id, site_id should be separated by tab as a delimiter. Can anyone explain?Thanks for ur support!!!Thanks,Guru

Default value & compress value in table

Gurunathan — Thu, 15 Oct 2009 07:56:26 GMT

Hi everyone,Can anyone explain to me, What is the use of Default value & compress value in the table(DDL)? If we are not using Default & compress value in the DDL, how it would be in the performace wise? Thanks in advance !!! Thanks,Guru

Need of Collect Statistics

Gurunathan — Fri, 25 Sep 2009 01:46:57 GMT

Hi. What is the need of collect statistics in teradata? Can anyone explain with suitable examples? Also, How can we choose the collect statistics columns?

[MLOAD] putting a '?' value

bruce_edwards — Mon, 12 Oct 2009 09:43:36 GMT

Hello all,Having just started working on MLOAD, I stumbled on this problem :When charging a file, the tool finds the correct number of lines.The tools then proceeds to put all those lines in the [name of table]_UV table.When I then make a sel * on this table, I can see that every field of every line has a value which is '?'I can understand that there is a conversion problem.The file layout is defined as every field being a (long) varchar, and is then cast or trimmed in the insert into query...

Loading space into a Decimal(15,2) column

Anand JP — Tue, 05 Sep 2006 02:05:19 GMT

Hi,

We are facing issues in loading a text file from a Mainframe system to Teradata database using Mulitload. Here are the details.

Problem Description :
In the text file that we are loading most of the records has "spaces" instead of packed decimal values for the column/field for which the error is being reported. Mulitload loads the records having columns with proper packed decimal values but rejects records which has spaces with error code 2679.

File Format : Text
Source Field datatype : Packed decimal (cobol comp3)
Target TD Column datatype : Decimal(15,2)
Error Message : 2679 The format or data contains a bad character

Has anyone encountered this problem before.

Please let me know your comments/suggestions.

With Regards,
Anand

COMP causing Mload faliure

Satish Mee — Tue, 29 Jan 2008 04:36:39 GMT

Hi Gurus,As we know we have different ways to Compress the Decimal data Like COMP-3,COMP-4,COMP-5 and COMPFor example if we have COLUMN given as SALARY S9(13)V99 Comp-3 , we create Teradata table as SALARY DECIMAL(15,2)and LAYOUT as .FIELD SALARY * DECIMAL(15,2) and Mload works fine.The alternate way is ,we can define the layout as .FIELD SALARY * CHAR(8) (we are computing it as 13+2/2 = 8( rounding 7.5) )the mention CAST(:SALARY AS DECIMAL(15,2) FORMAT '9(13)V9(2)S') in the DML phase (Insert phase) then Mload works fine.Problem we are facing is with COMP format .we dont know the relevent teradata datatype for COMP.I got a COPY BOOK which has a COLUMN as BALANCE S9(13)V99 COMP.I defined it as BALANCE DECIMAL(15,2) and tried defining the layout in above mentioned 2 ways ,But Mload is failing with error-2679.I knew the data doesnt has any Bad Chars , it contains 0.00 values.What is the relevant teradata data type for S9(13)V99 COMP ?Can you please give me solution for this..?Hope someone who worked on surely gives me a Answer ..Thanks In Advance

NetVault and Alert Policy

SchmoT — Wed, 07 Oct 2009 17:39:48 GMT

Our shop is having difficulty with our NetVault Backup failing due to what seems to be our alert policy through TASM killing "idle" sessions of the backup.Shortly after our upgrade to TD 12.0.2.20 we implemented a policy through Teradata Alert Policy Editor to abort idle sessions after 1 hour. We then noticed that our weekly NetVault backup was failing due to a "DBMS Restart or Session Reset". We tried adding the 2 NetVault users to the Exception list in the Sessions tab of Alter Policy Editor, but the backup still failed with the same restart/reset error as before.Last Friday afternoon we modified the policy to email instead of abort after 1 hr idle time. The backup was successful but we never got an email stating that the NetVault user had exceeded the 1 hour threshold.Is it possible that the policy is aborting some sort of internal session that is used by NetVault but is not recognized as a valid user to send an email about? We have another policy that emails our DBAs if a session is blocked and it DOES email when -internal session- blocks another user's session. This is what is so confusing to me.Is there something I am missing?Thank you,Frustrated

Varchar in Fast Export

Sandi — Sun, 29 Jul 2007 17:06:41 GMT

Hi ,
when i use fast export utility for unloading records from a column having data type "varchar" i am getting two dots (Junk characters) infront of each record. I don't want to cast this field to CHAR. Could anyone please help me to resolve this issue?

Thanks and Regards
Sandi

Collect Stats - can you copy them?

epfatboy — Fri, 02 Oct 2009 08:53:06 GMT

Is there a way to copy STATS collected on a table to a duplicate table?We have a process which we refer to as CLONE TABLE Processing. Basically when we are required to modify a large table rather than performing an ALTER TABLE we create a new table with the new attributes required and perform a FASTLOAD or INSERT INTO. The process to duration to make the changes this way out performs ALTER TABLE for large tables. the problem is collecting stats takes a long time. We are also noticing that table sizes increase dramatically if we alter table vs performing clone table processing. In a recent example we increased a table size by 100GB by adding a single attribute using alter VS CLONE... very strange.

DBC.DBQLogtbl Application id meaning/definitions

Vincent Gabrielli — Thu, 01 Oct 2009 17:07:08 GMT

Hello support team members, I need your help. in the DBC.DBQLogtbl there is a field named APPID (The application ID under which the query is submitted) does anyone know what UVSH stands for? Example you also find BTEQ, SAS, JDBC, TPUMPEXE, TSCOM3.OUT these are known applications id’s

Number of Sessions

LeoIssac — Wed, 12 Aug 2009 11:38:37 GMT

We have a facility to teach Multiload,Fastload and BTEQ to use multiple sessions. I wouldlike to understand how this setting works. I.e., If I specify, Set Sessions 5 in BTEQ script how does it work? for example, If I have 5 select statements, 5 insert statements in sequential order in BTEQ script how does Teradata manage the sessions and runs the script.Is there any documentation that explains how teradata sessions work?

ARCMAIN - Porting Data tables from V2R5 to TD 13

NagzTheTDMaster — Mon, 28 Sep 2009 11:47:09 GMT

Hi,I need to move a user along with the objects from V2R5 to TD13.I was able to archive it.But while copying it to TD13 it errors out saying unsupported rdbms.Isnt that possible to migrate the data from v2r5 to TD13.Please help.

Data Validation in Teradata

cvkr4u — Thu, 17 Sep 2009 02:37:27 GMT

Hi,Please help.How we can validate the Text file Data in teradata?ex:I have 100 records in source in loaded usng fast load .i got only 90 records in target.tell me the falt file validation in teradataCan you please help on this

How to find a primary key in teradata tables?

sunitha_cv — Fri, 15 May 2009 02:26:31 GMT

Hi,Actually,I am new to this teradata but i know basic concepts.we will create indexes when we create tables in teradata and will not mention primary keys.how to find a primary key in existing teradata table?Please let me know the solution.

Problems running TdGeoImportExport version 1.1

williamjh — Sun, 27 Sep 2009 18:20:13 GMT

I am trying to use the TDGeoImport utility to load some data. I can not get it to run under either Vista or XP.When using Vista I get and EXCEPTION_ACCESS_VIOLATION (0xc0000005) error from the JVM. Most suggestions regarding these errors suggest either the JVM or application have bugs or there is a security error. I have tried different directory permissions, different JVMs, disabling UAC - still no luck.Vista Log[font=Courier New]C:\Users\williamh\Documents\install\teradata\TdGeoImportExport\bin>"C:\Program Files\Java\jre6\bin\java" -classpath .;"C:\Users\williamh\Documents\install\teradata\TdGeoImportExport\bin\terajdbc4.jar";"C:\Users\williamh\Documents\install\teradata\TdGeoImportExport\bin\tdgssconfig.jar";. com.teradata.geo.TDGeoImport -l 172.16.3.16/wsadmin,xxxxxx -s wsadmin -f C:\Users\williamhLogon = 172.16.3.16/wsadmin,xxxxxxDatabaseName = wsadminData Source = C:\Users\williamhconnecting to 172.16.3.16 ... connected!-------------------------------------------importing layer Branch_mif to table BRANCH_MIF ...## A fatal error has been detected by the Java Runtime Environment:## EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x77d66739, pid=2628, tid=5644## JRE version: 6.0_15-b03# Java VM: Java HotSpot(TM) Client VM (14.1-b02 mixed mode, sharing windows-x86 )# Problematic frame:# C [ntdll.dll+0x66739]## An error report file with more information is saved as:# C:\Users\williamh\Documents\install\teradata\TdGeoImportExport\bin\hs_err_pid2628.log## If you would like to submit a bug report, please visit:# http://java.sun.com/webapps/bugreport/crash.jsp#[/font]Under XP I do not even get that far. I seem to have a PATH problem or be missing a DDL. Any ideas?XP Log[font=Courier New]C:\customer_data\xxxxxxxxxxx\TdGeoImportExport\bin>java -classpath .;terajdbc4.jar;tdgssconfig.jar;. com.teradata.geo.TDGeoImport -l 172.16.3.16/wsadmin,xxxxx -s wsadmin -f C:\Users\williamhjava.lang.UnsatisfiedLinkError: C:\customer_data\xxxxxxxx\TdGeoImportExport\bin\geojni.dll: This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem at java.lang.ClassLoader$NativeLibrary.load(Native Method) at java.lang.ClassLoader.loadLibrary0(Unknown Source) at java.lang.ClassLoader.loadLibrary(Unknown Source) at java.lang.Runtime.loadLibrary0(Unknown Source) at java.lang.System.loadLibrary(Unknown Source) at com.teradata.geo.TDGeoImport.main(TDGeoImport.java:869)===========================================Data importing failed![/font]

I can not install zhe Teradata Sql Assistant

yangshourong@gmail.com — Thu, 24 Sep 2009 21:39:05 GMT

I can not install Teradata Sql Assistant in windows7Is anybody give me more info?

Strip Linefeed/Tab characters

anil4yesu — Wed, 23 Sep 2009 13:59:08 GMT

I have notes field VARCHAR(72) that has some linefeed/tab characters. Is there an easy way to strip them off. I tried replace(col1,'OA'XC,' ') but it didn't like it.ThanksAnil

connection manager

papgust — Wed, 23 Sep 2009 01:17:00 GMT

Hi All,I need an answer to this question urgently.can we provide database name to TDPID parameter in connection manager?Please reply ASAP. Thanks in advance!!

Missing DLL

johnstg — Tue, 22 Sep 2009 22:22:50 GMT

HI,After instlalling the tools and utilities onto a WinXpSp2 desktop, Bteq gives and error the CAPUTL.DLL was not found.I've reinstalled and rebooted severaltimes, but the issue remains.Any suggestions ?

Fastload using INMOD

patricia_br — Mon, 21 Sep 2009 14:24:37 GMT

Hi friends,I need some real world examples of fastload scripts using inmod - Unix/ C. The fastload need to treat special character in the source data file before insert in the table. Can anyone help me with this?Thanks a lot!Patricia

Fastload error

sanjay_hyd — Wed, 16 Sep 2009 08:01:27 GMT

Hi All!!We have our teradata database on UNIX server. And recently we had teradata version upgrade from 6 to 7.I am working on a Teradata fastload script that worked correctly with out any error. But giving an error when executed in new version.The fastload script is as follows:[i].logon USER_ID/PASS_WD,.LOGTABLE ERR_DB.TABLE_NAME ;DROP TABLE ERR_DB.UV_table_name ;DROP TABLE ERR_DB.ET_table_name ;DELETE FROM DB.table_name ;set record unformatted;define emp_id (CHAR(12) ), org_name (CHAR(50) , NULLIF = '*'), prv_zip (CHAR(5) , NULLIF = '*'), last_nm (CHAR(40) , NULLIF = '*'), frst_nm (CHAR(20) , NULLIF = '*'), prof_pfx (CHAR(4) , NULLIF = '*'), address (CHAR(50) , NULLIF = '*'), city_nm (CHAR(50) , NULLIF = '*'), newlinechar (CHAR(1))file=file_name;show;begin loading DB.table_name errorfiles ERR_DB.ET_table_name, ERR_DB.UV_table_namecheckpoint 0 ;insert into DB.table_name ( emp_id, org_name, prv_zip, last_nm, frst_nm, prof_pfx, address, city_nm ) VALUES ( :emp_id, :org_name, :prv_zip, :last_nm, :frst_nm, :prof_pfx, :address, :city_nm) ; end loading;logoff;[/i]Encountering the error "syntax error at line 13 : `(' unexpected ".Googled this issue to find exact reason. Found few posts which say the error is due to "OS version".Does any one has something to say about this?Thanks in advance!Sanjay!