TAW_11 Chapter 2, statements, functions and expressions Flashcards
Type I truncates values?
False, Integers are ROUNDED, not truncated
The type I value range is from what to what?
-2,147,483,648 to 2,147,483,647
There are 7 basic calculations. What are they
+,-,*,/,DIV (rounded down),MOD,**
Type F is extremely accurate
No, only use for approximations as the decimals are often unpredictable
when would a type F be needed?
There are special aggregations of the SELECT statement that require it
What is the maximum number of decimals in a type P
14
What is the requirement for number of digits to the left
of the decimal in type P?
At least one digit to the left of the decimal must be present
Which can hold larger numbers, type F or DECFLOAT
The DECFLOAT are larger and more accurate than type F
If a arithmetic expression contains a type P, is the internal calc based on type P?
Yes, all is converted to type P unless a type F is also present
The system will use DECFLOAT as the interim if what is true
If at least one field is of type DECFLOAT and no type P or F fields exist
There are 9 statements for processing character type data. What are they
CONCATENATE SHIFT OVERLAY SPLIT FIND TRANSLATE REPLACE CONDENSE WRITE..TO..
What did the FIND command replace?
The SEARCH command
Two of the character type statements cannot be used with type X fields. What are they?
CONDENSE and OVERLAY
What must be added to the 7 processing statements for character processing to use them with type X fields?
add IN BYTE MODE
Name the 8 logical operators
CA - contains any NA - not any CO - contains only CP - contains pattern NP - not pattern CN - contains no CS - contains string NS - no string