- Select statement to retrieve the data
- File format, mode, path etc.
Step1 - Remember while importing the data
- Insert OR update or up sert statement
- File path, mode, structure and format
Step2 - Remember while importing the data
- Insert OR update or up sert statement
- File path, mode, structure and format
Modes
1.Data mode
This mode also be called as Record mode Here one by one Record will be process
Here Null Represent with ‘zero’[Integer], or spaces[STRINGS]
date | date |
date | date |
2.INDICATOR MODE
It is just like data mode, null are represented with Indicate bytes[“Nulls are treated as nulls only”]
Indicator bytes | date | date |
Indicator bytes | date | date |
3.Report mode
It is fields by field format mode
4.DIFF[Date Interchange file Format mode]
It is used across various pc ways plot form such as excel, Fox pro,[Loater under Lotus – 1,2,-3 etc]
Format option
1.Format option
A Two-byte integer n followed by n bytes of data. Followed by An End – of- Record market, either X ‘OA’ OR X’OD’
2.Binary
A Two-byte integer, n followed by n bytes of data.
3.TEXT
An Arbitrary number of bytes followed by an end- of- Record market, either X’OA’ OR X’OD’
4.UNFORMAT
Exported as it is Received from CLIV2 with out any client modifications
Note
In text format end of the mandatory
FREQUENTILY USE FILE MODES IN REAL TIME
Un format [FJXED TEXT]
2.VARTEXT[Delimiter]
123 | Vinay | KKK |
8345 | Modhu | |
58 | Krish | Kumar |
ID Max 10 character
Name Max 30 character
Column Delimiter:?
Row Delimiter: CRLF[Enter key character]
Note
Othe Delimiters
Space, Tab,; ;, etc
LOGON COMMAND
This command is used to log in to the system, After Logon it create as session, during session only the user can operate this queries
INTERACTIVE
Syntax - LOGON Tdpid OR IP ADDRESS OR SERVER NAME/<user name><Enter key> password=<pass word>
Ex: TD12:.LOGON 127.0.0.1/DBC<Enter key>
Pass word=DBC
Batch mode
Syntax - Logon tdpid or IP Address or server name/<USER NAME>,<Password>[‘Acctid’]
Ex: TD12 .Logon 127.0.0.1/DBC,DBC
BTEQ[Basic Tera data Query]
Run is Two Modes
- Interactive
- Batch mode
Navigation
1st way: Start Run
BTEQ
2ND way: Start Programs
Tera data client
Tera data BTEQ[Win BTEQ]
Real Time usages:
- The Unix Environment we use BTEQ by Firing day to day Query[Like Query man, SQL Assissent in window]
- For Testing perspective for tester use
- For out day to day operations[Importing And exporting etc] we use it