IT Experts Central

RSS Feed Homepage

Articles: 1, 2, 3, 4

Prevent Old Documents to Replicate in Lotus Notes Database
2007-05-16 16:10:00
Normally we leave this field blank. However, there are instances that we need to place certain date in this particular field to prevent replication problem. Do you know what field is it? (more…)
More About: Notes , Database , Lotus , Document , Taba

How to set up Replication on Lotus Notes R5.0
2007-05-16 15:55:00
Replication is performed on the database to enable offline capability on an application. In this way, users can perform the necessary action on the application without connecting to the server. Follow the steps provided on setting up the replication on your Lotus Notes application. (more…)
More About: Replica

SQL*Unloader - The Method of Unloading Data
2007-05-13 16:49:00
Since Oracle provide SQL*Load er, you might think that there is a SQL *Unloader. The truth is there is no SQL *Unloader. The following script will do what your looking for unloading data from the database. The output file can be use as the control file for the SQL*Loader . (more…)
More About: Data , Method , Loading

SQL Loader Control File Generator
2007-05-13 16:42:00
Manually creating control files is an error-prone process. The following SQL script (controlfile.sql) can be used to generate an accurate control file for a given table. The script accepts a table name and a date format (to be used for date columns), and generates a valid control file to use with SQL*Load er for that table. (more…)
More About: File , Generator , Genera , Control

Oracle Loader Log File and Logging Information
2007-05-13 15:48:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Records in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Conditions Oracle Loader Log File and Logging Information Every loading execution of SQL *Loader, a log file is created. The log file contains the detailed summary of the loading and description of errors encountered. (more…) Previous
More About: Form

Oracle SQL Loader Specifying Field Conditions
2007-05-13 15:44:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Records in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Condition s Oracle Loader Log File and Logging Information Field Condition Clause A field condition is a statement about a field in a logical record that evaluates as true or false. It is used in the NULLIF and DEFAULTIF clauses, as well as in the WHEN clause. This is also the same with CONTINUEIF clause. (more…) Previous Next
More About: Conditions

Discarded Records in SQL Loader Discard File
2007-05-13 14:59:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Record s in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Conditions Oracle Loader Log File and Logging Information SQL *Loader can create discard file for all records which do not meet the data loading criteria. Discarded records do not satisfy the WHEN clause specified in the control file. This records are different from rejected records. Discarded record doesn’t mean they are bad data. Discarded records are not inserted to the database. (more…) Previous Next

Rejected Records in SQL Loader Bad File
2007-05-13 14:46:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Record s in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Conditions Oracle Loader Log File and Logging Information Discarded and Rejected Records Not all records read by SQL *Loader from the data file will be inserted to the database. All rejected and discarded records are placed in bad file. Records can be rejected by SQL *Loader and/or the Oracle database. (more…) Previous Next

SQL Loader Input Data and Data File
2007-05-13 14:01:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Records in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Conditions Oracle Loader Log File and Logging Information Input Data and Data File SQL *Loader reads data from one of more files specified in the control files. There three record formats of data file, they are Fixed-Record, Variable-Record and Stream Record Format. (more…) Previous Next

SQL Loader Control File
2007-05-13 12:20:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Records in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Conditions Oracle Loader Log File and Logging Information Control File SQL *Loader Control File is a text file that contains the information that defines how the data will be loaded. This file contains definition of the destination table, columns and it’s data types. It also includes definition of how the data will be read by defining the field limiter used in the data file. (more…) Previous Next

SQL Loader Data Types
2007-05-13 12:19:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Records in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Conditions Oracle Loader Log File and Logging Information SQL *Loader Data Types SQL *Loader is grouped into portable and non-portable data types. Each group is sub-grouped into value data type and length-value data type. (more…) Previous Next

Oracle SQL Loader Overview
2007-05-13 11:21:00
Table of Contents Oracle SQL Load er Overview SQL Loader Data Types SQL Loader Control File SQL Loader Input Data and Data File Rejected Records in SQL Loader Bad File Discarded Records in SQL Loader Discard File Oracle SQL Loader Specifying Field Conditions Oracle Loader Log File and Logging Information Overview SQL*Loader is the primary method to load data to Oracle database from external files. It has a powerful data parsing engine which puts little limitation on the format of the data in the datafile. (more…) Next

Unix Shell Script Functions
2007-05-02 15:44:00
Table of Contents Unix Shell Script s Introduction Basic Structure of Unix Shell Script Declaring Variables in Unix Shell Script Conditional Statements in Unix Shell Scripts What’s the Case Statement in Unix Shell Scripts? Looping in Unix Shell Scripts Unix Shell Script Function s Functions are named code blocks that can be referenced and executed as a unit. Functions have an option to take variable number of arguments and may return a value. If function returns a value, calling the function is usually part of an expression. (more…) Previous

Looping in Unix Shell Scripts
2007-05-01 15:02:00
Table of Contents Unix Shell Scripts Introduction Basic Structure of Unix Shell Script Declaring Variables in Unix Shell Script Conditional Statements in Unix Shell Scripts What’s the Case Statement in Unix Shell Scripts? Loop ing in Unix Shell Scripts Unix Shell Script Functions Loops Loops are use to perform certain task multiple times. Using loops helps minimize placing code multiple time performing similar functions. Loops in Unix scripting uses for and while loops. (more…) Previous Next
More About: Ping

What’s the Case Statement in Unix Shell Scripts?
2007-05-01 15:02:00
Table of Contents Unix Shell Scripts Introduction Basic Structure of Unix Shell Script Declaring Variables in Unix Shell Script Conditional Stat ements in Unix Shell Scripts What’s the Case Statement in Unix Shell Scripts? Looping in Unix Shell Scripts Unix Shell Script Functions The case statement is similar to if .. else if .. else statement which performs specific statement/s if there are three or more conditions. (more…) Previous Next

Conditional Statements in Unix Shell Scripts
2007-05-01 09:39:00
Table of Contents Unix Shell Scripts Introduction Basic Structure of Unix Shell Script Declaring Variables in Unix Shell Script Condition al Stat ements in Unix Shell Scripts What’s the Case Statement in Unix Shell Scripts? Looping in Unix Shell Scripts Unix Shell Script Functions Conditional Statements Conditional statements are use to perform specific action/s based on a given conditions. (more…) Previous Next

Declaring Variables in Unix Shell Script
2007-05-01 09:13:00
Table of Contents Unix Shell Script s Introduction Basic Structure of Unix Shell Script Declaring Varia bles in Unix Shell Script Conditional Statements in Unix Shell Scripts What’s the Case Statement in Unix Shell Scripts? Looping in Unix Shell Scripts Unix Shell Script Functions Variables Variables are use to store information. The syntax of declaring variables is shown below: (more…) Previous Next

Basic Structure of Unix Shell Script
2007-05-01 07:00:00
Table of Contents Unix Shell Script s Introduction Basic Structure of Unix Shell Script Declaring Variables in Unix Shell Script Conditional Statements in Unix Shell Scripts What’s the Case Statement in Unix Shell Scripts? Looping in Unix Shell Scripts Unix Shell Script Functions The shell script structure consists of header, declaration and body. These three sections are basic structure of shell script. But script can run with header and body section only. Declaration section is useful for reading and passing values within the script. (more…) Previous Next

Unix Shell Scripts Introduction
2007-05-01 06:59:00
Table of Contents Unix Shell Scripts Intro duction Basic Structure of Unix Shell Script Declaring Variables in Unix Shell Script Conditional Statements in Unix Shell Scripts What’s the Case Statement in Unix Shell Scripts? Looping in Unix Shell Scripts Unix Shell Script Functions Introduction A shell script is a script written for the shell or command line interpreter of an operating system like Unix. This script contains list of commands that are run in sequence. (more…) Next

History of HTML
2007-04-16 05:52:00
Table of Contents Hist ory of HTML HTML Essentials Basic HTML Tags HTML Formatting HTML List HTML Table Origin of HTML Hypertext Markup Language (HTML) is a markup language used in creating web pages and displayed in web browser. This is originally defined by Tim Berners Lee and further enhanced by Internet Engineering Task Force (IETF) - develops and promotes Internet standards, cooperating closely with the W3C and ISO/IEC standard bodies; and dealing in particular with standards of the TCP/IP and Internet protocol suite. HTML is now an international standard (ISO/IEC 15445:2000). Later HTML specifications are maintained by the World Wide Web Consortium (W3C). Next © Mark Marucot for IT Experts Central, 2007. | Permalink | One comment Add to del.icio.us Search blogs linking this post with Technorati Want more on these topics ? Browse the archive of posts filed under HTML.
More About: Html , Tory

Dissecting Web 2.0
2007-04-16 05:33:00
When you ask someone about the definition of Web 2.0 , you will hear blogging, AJAX, wikis, Google Suggest and many other website services available around the web. Based on these keywords, Web 2.0 is the next generation of Internet based services that allow people to collaborate and share information online. Now let’s dissect Web 2.0. (more…)
More About: Diss

Planning your Website using the 5Ws
2007-04-16 05:29:00
In planning a website you need to answer the 5 Ws. They are Who, What, When, Where, Why and How. In this process, it’s important to write down any information you gathered. (more…)
More About: Website , Planning , Sing , Plan

Ideology of Web Development
2007-04-16 05:24:00
Web development is a wide domain that consists of all fields of creating web site in cyberspace. Web development is divided into different layers. They are presentation, business and data layer. (more…)
More About: Web Development , Development , Ideology , Develop , Ology

AJAX Overview
2007-04-15 09:11:00
Overview of AJAX AJAX short for Asynchronous Javascript + XML is technology for developing web applications which was used years before it was coined by Jesse James Garrett in February 2005. This was overlooked by web developers until Gmail and Google used it in its applications such as Google Map and Google Suggest. (more…)
More About: Ajax , Overview

How to determine the working days between two dates in Excel?
2007-04-14 15:04:00
If I have a Start Date and End Date columns, how to I determine how many working days between them? (more…)
More About: Dates , Days , King , Excel , Working

Oracle Sequence Exceeds The Limit
2007-04-14 14:59:00
Sequence is one of the useful features of Oracle . This is used in column requiring auto-numbering. This automatically increment the value on a given increment range. What if these sequences are almost near to it’s max value? What will happened then? (more…)
More About: Sequence