IMPORTANT STEPS TO REMEMBER WHILE EXPORTING THE DATA
Step1 - Remember while importing the data
Step2 - Remember while importing the data
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]
2.INDICATOR MODE It is just like data mode, null are represented with Indicate bytes[“Nulls are treated as nulls only”]
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]
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]
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
Navigation 1st way: Start Run BTEQ 2ND way: Start Programs Tera data client Tera data BTEQ[Win BTEQ] Real Time usages:
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox