What is the effect of the OPTIONS statement ERRORS=1?

Answer Posted / joshu

options error :set a limit for data errors.
options error=1 then after executing if errors are more than 1 it stops the session.
options error =max (default)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the basic and unique feature of dotnet

2007


how to work search engine? plz detail answer me.

1697


If i have a dataset queried from Sql and I would like to insert the dataset into a specific node in an xml document how do I do this

1922


What binary value will be internally stored for NULL for the type S9(1) COMP 3 in mainframe

1769


Definition of Singleton Class? what is the Purpose of it? what is the advantage?

1872


there are N number of matchboxes numbered 1...N.each matchbox contain various number of stick.Two player can alternatevely pick some amount of stick from the higest stick containing box . The player is condidered win if there is no stick after his move.Find the final move so that the move player win. Note:In case the number of stick is equal ,pick the stick from the higest numbered box. eg: 3 box contain stick as:1,1,1. if u take 1 stick from 3rd numbred box you will any how win the match.

2634


How to call dll API sub routine in VB Form.

2131


what is best way to create a Thread class & why?

1871


what is the difference between Windows application and Unix application?

2401


Write a pascal program to calculate the sum of the first 100 even number and odd number

4188


what is the last ant version you worked?how to get it

1723


Wrtite a JCL for sorting a file with start from 36 postion lenth 9 excluding a num eq to 98768. for 3 marks mainframe

1690


Plz sent me in .net 2.0 interview Question & answers?

1925


Find out the list of roles which gives access to GUI activities? thanks in advance

1954


hi all, i need ur help in preparing a sql which performs scd2, i mean i have a scd2 mapping i need a sql which can give me same result as scd2 mapping, SRC table: cust_no, loc 01 abc 02 xyz TGT table: pm_ky cust_no loc current_flag 1 01 abc Y 2 02 xyz Y cust 1 has changed his loc to xyz then it loads into TGT table as below, pm_ky cust_no loc current_flag 1 01 abc N 2 02 xyz Y 3 01 xyz Y i need sql to get the above result, hope got me question, Any suggestion will be appreciate.. thanks, Vinod

1905