Group Discounts available for 3+ students and Corporate Clients

IMPORTANT STEPS TO REMEMBER WHILE EXPORTING THE DATA

IMPORTANT STEPS TO REMEMBER WHILE EXPORTING THE DATA

  1. Select statement to retrieve the data
  2. File format, mode, path etc.

 

Step1 – Remember while importing the data

  1. Insert OR update or up sert statement
  2. File path, mode, structure and format

 

Step2 –  Remember while importing the data

  1. Insert OR update or up sert statement
  2. File path, mode, structure and format

 

Modes

1.Data mode

2This mode also be called as Record mode Here one by one Record will be process

2Here Null Represent with ‘zero’[Integer], or spaces[STRINGS]

datedate
datedate

 

2.INDICATOR MODE

It is just like data mode, null are represented with Indicate bytes[“Nulls are treated as nulls only”]

Indicator bytesdatedate
Indicator bytesdatedate

 

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

 

Screenshot_85

 

 

FREQUENTILY USE FILE MODES IN REAL TIME

Un format  [FJXED TEXT]

Screenshot_86

 

 

2.VARTEXT[Delimiter]

123VinayKKK
8345Modhu
58KrishKumar

ID 2  Max 10 character

Name 2  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:2.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 2 .Logon 127.0.0.1/DBC,DBC

BTEQ[Basic Tera data Query]

Run is Two Modes

  1. Interactive
  2. Batch mode

 

Navigation

1st way: Start 2 Run  2 BTEQ

2ND way: Start  2 Programs  2 Tera data client  2 Tera data BTEQ[Win BTEQ]

  

Real Time usages:

  1. The Unix Environment we use BTEQ by Firing day to day Query[Like Query man, SQL Assissent in window]
  2. For Testing perspective for tester use
  3. For out day to day operations[Importing And exporting etc] we use it

 

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on IMPORTANT STEPS TO REMEMBER WHILE EXPORTING THE DATA"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6