Cek definition file (pld) June 18, 2009

go to the file path and use  ” grep -i ‘$head’ ” (without “) to check definitions

ex:
# grep -i ‘$head’ INVMTXIT.pll
FDRCSID(‘$Header: INVMTXIT.pld 115.54 2004/05/26 16:58:14

Oracle apps GL Interface Code June 17, 2009

Period Error Codes
——————
EP01 This date is not in any open or future enterable period.
EP02 This set of books does not have any open or future enterable periods.
EP03 This date is not within any period in an open encumbrance year.
EP04 This date is not a business day.
EP05 There are no business days in this period.

Unbalanced Journal Error Codes
——————————
WU01 Warning: This journal entry is unbalanced. It is accepted because
suspense posting is allowed in this set of books.
EU02 This journal entry is unbalanced and suspense posting is not allowed in
this set of books.
EU03 This encumbrance journal entry is unbalanced and the Reserve for
Encumbrance account is not defined.

Flexfield Error Codes
———————
EF01 This Accounting Flexfield is inactive for this accounting date.
EF02 Detail posting not allowed for this Accounting Flexfield.
EF03 Disabled Accounting Flexfield.
EF04 This is an invalid Accounting Flexfield. Check your cross-validation
rules and segment values.
EF05 There is no Accounting Flexfield with this Code Combination ID.

Foreign Currency Error Codes
—————————-
EC01 A conversion rate must be entered when using the User conversion rate
type.
EC02 There is no conversion date supplied.
EC03 A conversion rate type or an accounted amount must be supplied when
entering foreign currency journal lines.
EC06 There is no conversion rate for this currency, conversion type and
conversion date.
EC08 Invalid currency code.
EC09 No currencies are enabled.
EC10 Encumbrance journals cannot be created in a foreign currency.
EC11 Invalid conversion rate type.
EC12 The entered amount must equal the accounted amount in a functional or
STAT currency journal line.
EC13 The entered amount multiplied by the conversion rate must equal the
accounted amount.
ECW1 Warning: Converted amounts could not be validated because the
conversion rate type is not specified.

Budget Error Codes
——————
EB01 A budget version is required for budget lines.
EB02 Journals cannot be created for a frozen budget.
EB03 The budget year is not open.
EB04 This budget does not exist for this set of books.
EB05 The encumbrance_type_id column must be null for budget journals.
EB06 A period name is required for budget journals.
EB07 This period name is not valid. Check calendar for valid periods.
EB08 Average journals cannot be created for budgets.
EB09 Originating company information cannot be specified for budgets.

Encumbrance Error Codes
———————–
EE01 An encumbrance type is required for encumbrance lines.
EE02 Invalid or disabled encumbrance type.
EE03 Encumbrance journals cannot be created in the STAT currency.
EE04 The BUDGET_VERSION_ID column must be null for encumbrance lines.
EE05 Average journals cannot be created for encumbrances.
EE06 Originating company information cannot be specified for encumbrances.

Reversal Error Codes
——————–
ER01 A reversal period name must be provided.
ER02 This reversal period name is invalid. Check your calendar for valid
periods.
ER.
03 A reversal date must be provided
ER04 This reversal date is not in a valid period.
ER05 This reversal date is not in your database date format.
ER06 Your reversal date must be the same as or after your effective date.
ER07 This reversal date is not a business day.
ER08 There are no business days in your reversal period.
ER09 Default reversal information could not be determined.

Descriptive Flexfield Error Codes
———————————
ED01 The context and attribute values do not form a valid descriptive
flexfield for Journals – Journal Entry Lines.
ED02 The context and attribute values do not form a valid descriptive
flexfield for Journals – Captured Information.
ED03 The context and attribute values do not form a valid descriptive
flexfield for Value Added Tax.

Miscellaneous Error Codes
————————-
EM01 Invalid journal entry category.
EM02 There are no journal entry categories defined.
EM03 Invalid set of books id.
EM04 The value in the ACTUAL_FLAG must be “A” (actuals), “B&
quot; (budgets), or
“E” (encumbrances).
EM05 The encumbrance_type_id column must be null for actual journals.
EM06 The budget_version_id column must be null for actual journals.
EM07 A statistical amount belongs in the entered_dr(cr) column when entering
a STAT currency journal line.
EM09 There is no Transaction Code defined.
EM10 Invalid Transaction Code.
EM12 An Oracle error occurred when generating sequential numbering.
EM13 The assigned sequence is inactive.
EM14 There is a sequential numbering setup error resulting from a missing
grant or synonym.
EM17 Sequential numbering is always used and there is no assignment for this
set of books and journal entry category.
EM18 Manual document sequences cannot be used with Journal Import.
EM19 Value Added Tax data is only valid in conjunction with actual journals.
EM21 Budgetary Control must be enabled to import this batch.
EM22 A conversion rate must be defined for this accounting date, your
default conversion rate type, and your dual currency.
EM23 There is no value entered for the Dual Currency Default Rate Type
profile option.
EM24 Average journals can only be imported into consolidation sets of books.
EM25 Invalid average journal flag. Valid values are “Y”, “N&
quot;, and null.
EM26 Invalid originating company.
EM27 Originating company information can only be specified when intercompany
balancing is enabled..

'P' indicates that Journal Import passed this line successfully but other
lines in the same transaction failed. 

'PROCESSED' indicates that journal import passed the entire transaction
successfully and has created a journal for the transaction. 

'CORRECTED' indicates that the line was in error and was corrected through
the Correct Journal Import form. 

refer to metalink doc 112804.1

Kisah sapi, monyet, anjing dan manusia March 6, 2009

Di awal zaman, Tuhan menciptakan seekor sapi.

Beliau berkata kepada sang sapi “Hari ini kuciptakan kau! Sebagai
sapi engkau harus pergi ke padang rumput. Kau harus bekerja di bawah
terik matahari sepanjang hari. Kutetapkan umurmu sekitar 50 tahun.”

Sang Sapi keberatan “Kehidupanku akan sangat berat selama 50 tahun.
Kiranya 20 tahun cukuplah buatku. Kukembalikan kepadamu yang 30 tahun”
Maka setujulah Tuhan.

Di hari kedua, Tuhan menciptakan monyet. “Hai monyet, hiburlah
manusia. Aku berikan kau umur 20 tahun!” Sang monyet menjawab
“What? Menghibur mereka dan membuat mereka tertawa?
10 tahun cukuplah. Kukembalikan 10 tahun padamu”
Maka setujulah Tuhan.

Di hari ketiga, Tuhan menciptakan anjing. “Apa yang harus kau lakukan
adalah menjaga pintu rumah majikanmu. Setiap orang mendekat kau harus
menggongongnya. Untuk itu kuberikan hidupmu selama 20 tahun!” Sang
anjing menolak : “Menjaga pintu sepanjang hari selama 20 tahun ? No
way.! Kukembalikan 10 tahun padamu”.
Maka setujulah Tuhan.

Di hari keempat, Tuhan menciptakan manusia. Sabda Tuhan: “Tugasmu
adalah makan, tidur, dan bersenang-senang. Inilah kehidupan. Kau akan
menikmatinya. Akan kuberikan engkau umur sepanjang 25 tahun!”
Sang manusia keberatan, katanya “Menikmati kehidupan selama 20 tahun?
Itu terlalu pendek Tuhan. Let’s make a deal. Karena sapi
mengembalikan 30 tahun usianya, lalu anjing mengembalikan 10 tahun,
dan monyet mengembalikan 10 tahun usianya padamu, berikanlah semuanya
itu padaku. Semua itu akan menambah masa hidupku menjadi 75 tahun.
Setuju ?”
Maka setujulah Tuhan.

AKIBATNYA…………………………

Pada 25 tahun pertama kehidupan sebagai manusia dijalankan (kita
makan, tidur dan bersenang-senang)

30 tahun berikutnya menjalankan kehidupan layaknya seekor sapi (kita
harus bekerja keras sepanjang hari untuk menopang keluarga kita.)

10 tahun kemudian kita menghibur dan membuat cucu kita tertawa dengan
berperan sebagai monyet yang menghibur.

Dan 10 tahun berikutnya kita tinggal dirumah, duduk didepan pintu,
dan menggonggong kepada orang yang lewat.

Efisiensi Andersen Consulting March 6, 2009

Minggu lalu, saya pergi makan malam bersama beberapa teman kantor di sebuah restoran yang kabarnya cukup laris di daerah kota (untuk yang belum tahu, di Jakarta ada yang dinamakan daerah kota). Saat memesan makanan, saya perhatikan pelayan yang melayani kami membawa sepasang sendok di saku bajunya.

Sedikit aneh, tapi saya tidak begitu peduli. Namun, saat pesanan kami mulai diantar, saya melihat pelayan lain membawa pula sepasang sendok disaku bajunya. Saya jadi tertarik untuk melihat sekeliling dan ternyata memang benar dugaan saya, semua pelayan restoran tersebut membawa sepasang sendok di saku baju masing-masing. Saya jadi ingin bertanya. “Mas kenapa semua pelayan di sini membawa sepasang sendok di sakunya?” tanya saya yang datang membawa piring sate. “Oh begini mas,” jawab si pelayan, “pemilik restoran ini memutuskan untuk menyewa Andersen Consulting, ahli dalam hal analisa efisiensi kerja, untuk memperbaiki kinerja di restoran ini.

Setelah mereka analisa selama beberapa bulan, mereka menyimpulkanbahwa pelanggan restoran ini menjatuhkan sendok makan mereka sebanyak 73,84 persen lebih sering dibandingkan peralatan makan lain yang ada di meja. Menurut Andersen Consulting, itu berarti rata rata 3 pelanggan menjatuhkan sendok per meja setiap jamnya. Jika saja semua karyawan restoran mengantisipasi hal itu, berarti kita bisa mengurangi waktu yang terbuang untuk pulang pergi ke dapur mengambil sendok pengganti dan menghemat waktu 1,5 jam waktu kerja per-shift.”

Saking kagumnya dengan penjelasan si pelayan, tanpa sengaja saya menyenggol salah satu sendok yang ada di meja. Segera saja si pelayan mengambil gantinya dari saku baju sambil berujar, “Betulkan Pak, saya tidak harus pergi kedapur sekarang untuk mengambil sendok pengganti untuk Bapak!” Saya hanya bisa melongo dengan kejadian itu. Tapi, kisah belum berakhir di situ. Ketika pelayan lain menghidangkan pesanan tambahan, saya tetap memperhatikan sekeliling dan satu lagi hal tampak aneh. Saya perhatikan hampir semua pelayan pria memasang benang yang menyembul diujung ritsluiting celana mereka. Benang itu diikaitkan ke ujung kancing terbawah dari baju.

Lagi lagi rasa ingin tahu mengusik saya. Sebab, ternyata pelayan perempuan tak memakai aksesoris benang tersebut. Ketika si pelayan tadi datang, saya menanyakan soal benang itu. “Wah Bapak ini orangnya perhatian sekali ya. Tidak semua pelanggan disini memperhatikan hal-hal sedetail Bapak,” puji si pelayan sedikit menggombal. Saya hanya tersenyum kecil. Apa anehnya orang suka memperhatikan detail? “Ini juga hasil analisa Andersen Consulting Pak,” katanya melanjutkan, “Mereka menyimpulkan bahwa kami pun harus menghemat waktu yang kami habiskan di kamar kecil ketika buang air kecil. Dengan tali yang dikaitkan ke si “Adik” ini (katanya sambil menunjuk tali itu), kami tidak harus menggunakan tangan ketika mengeluarkannya.

Berarti kami akan terbebaskan dari keharusan membasuh tangan setelah buang air kecil. Dan itu menghemat waktu yang terbuang di kamar kecil sebesar 25,92 persen.” Hampir tersedak saya mendengarkan penjelasan itu. “Memang, dengan tali itu tangan jadi terbebas untuk memegang si “Adik”. Tapi, bagaimana caranya untuk memasukkannya kembali ke posisi semula?” tanya saya menyelidik. Dengan setengah berbisik si pelayan berucap, “Andersen Consulting tidak menjelaskan secara spesifik tentang hal itu. Nggak tahu dengan yang lain Pak. Tapi, kalau saya sih pakai sendok yang ada disaku baju ini.”

DBMS Job (How to) January 7, 2009

Submit a job

DECLARE
  l_job NUMBER := 0;
BEGIN
  DBMS_JOB.SUBMIT(l_job,'procedure_name;',sysdate,TRUNC(sysdate)+1+1/288);
END;
/

Run a job now

EXEC dbms_job.run(job_no);

Mark a job as not broken

(If a job fails to successfully execute it will go into a broken state after 16 attempts. To reset, issue command below)

EXEC dbms_job.broken(jobno, FALSE);

Remove a submitted job

EXECUTE DBMS_JOB.REMOVE(jobno);

Assign job to RAC instance

EXECUTE  DBMS_JOB.INSTANCE(job=>123, instance=>1);

Monitor jobs

(See created jobs)

SELECT job, what, next_date, next_sec FROM user_jobs;

(Jobs that are currently running)

SELECT * FROM user_jobs_running;

Compile Form Builder in Oracle apps R12 January 7, 2009

UNIX

First, set up the environment OracleAS 10.1.2 environment as for the builder. The following examples demonstrate use of the compiler. You will need to modify the directory paths to match your own environment.

frmcmp_batch.sh module=/TEST/testappl/au/12.0/forms/US/ARXTWMAI.fmb userid=APPS/APPS output_file=/TEST/testappl/ar/12.0/forms/US/ARXTWMAI.fmx module_type=form compile_all=special

frmcmp_batch.sh module=/TEST/testappl/au/12.0/resource/APPCORE.pll userid=APPS/APPS output_file=/TEST/testappl/au/12.0/resource/APPCORE.plx module_type=library compile_all=special

Windows

On Windows, you can launch the Forms compiler from the Start Menu. The compiler displays an input form UI where you can enter the parameters. You must have set the environment variables in the Registry first, as described above in the Forms Builder section.

Alternatively, you can run the compiler from a command prompt (Start -> All Programs -> Accessories. You can also set environment variables in the command prompt window, which will override any registry settings for the current command prompt window instance. For example, you could run the following

c:\TEMP>set FORMS_PATH=d:\AppsR12\au\12.0\forms\US;d:\AppsR12\au\12.0\resourcec:\TEMP>set EVENT_10932=8

c:\TEMP>set DE_DISABLE_PLS_512=1

c:\TEMP>set FORMS_FLAG_DIFFERENT_SUBORD=1

c:\TEMP>d:\iDS10.1.2\bin\frmcmp.exe module=d:\AppsR12\au\12.0\forms\US\ARXTWMAI.fmb userid=APPS/APPS output_file=d:\AppsR12\ar\12.0\forms\US\ARXTWMAI.fmx module_type=form compile_all=special

c:\TEMP>d:\iDS10.1.2\bin\frmcmp.exe module=d:\AppsR12\au\12.0\resource\APPCORE.pll userid=APPS/APPS output_file=d:\AppsR12\au\12.0\resource\APPCORE.plx module_type=library compile_all=special

——————————————————————————————————————————————–

Why compile forms with compile_all=special?

compile_all=special was originally introduced as a workaround for a bug that was fixed some time ago. The main reason it is still recommended for Oracle Applications is due to the way attached libraries are inherited from other attached libraries, and the difficulties in subsequently removing them if added by mistake. For example, if a new library is attached to CUSTOM.pll, that library also becomes directly attached to every form or library that has CUSTOM.pll attached, once the higher level object has been re-compiled. With compile_all=yes, the new library would end up attached to both the source and generated objects, and removing it would be extremely difficult: as well as removing it from CUSTOM.pll, you would have to remove it from every library or form that had CUSTOM.pll attached.

With compile_all=special, the source is not updated, and only the generated files (.plx and .fmx) have the new library attached. In the case where someone has mistakenly attached a library to CUSTOM.pll, (for example when they do not follow Oracle customization standards, and attach an Applications product library), you simply need to delete it from CUSTOM.pll, regenerate all the forms and libraries, and it will be gone. If you never customize, or if you follow the standards documented in the Oracle Applications Developer’s Guide, the use of compile_all=yes should never cause this kind of problem, but we still recommend that you use compile_all=special.

for more information, visit metalink (Note 191529.1 )

Create Value set in oracle apps based on another value set January 7, 2009

WHERE PRODUCT_CODE IN (‘AP’,'AR’,'FA’,'GL’)
AND APPLICATION_SHORT_NAME IN (‘AR’,'OFA’,'SQLAP’,'SQLGL’)
AND :$FLEX$.XXX_GI_ANTAR_MODULE = ‘N’

note : ‘XXX_GI_ANTAR_MODULE ‘ IS another value set

Spell Number Script With PL/SQL January 6, 2009

This is function for generate spell number

CREATE OR REPLACE function spell_number(p_number in number)
return varchar2
as
type myArray is table of varchar2(255);
l_str    myArray := myArray(”,
‘ thousand ‘,’ million ‘,
‘ billion ‘,’ trillion ‘,
‘ quadrillion ‘,’ quintillion ‘,
‘ sextillion ‘, ‘ septillion ‘,
‘ octillion ‘,’ nonillion ‘,
‘ decillion ‘, ‘ undecillion ‘,
‘ duodecillion ‘);
l_num varchar2(50) default trunc(p_number);
l_return varchar2(4000);
begin
for i in 1 .. l_str.count loop
exit when l_num is null;
if (to_number(substr(l_num,length(l_num)-2,3))<>0) then
l_return := to_char(to_date(substr(l_num,length(l_num)-2,3),’J'),’Jsp’) || l_str(i) || l_return;
end if;
l_num := substr(l_num,1,length(l_num)-3);
end loop;
return l_return;
end;
/

Compile Form Builder in Oracle Apps 11i January 6, 2009

run env file before execute this script,

f60gen Module=BILLED_NEW_CHARGE.fmb Userid=apps/apps060815 Module_Type=FORM Module_Access=FILE Output_File=/oracle1/prodappl/ar/11.5.0/forms/US/BILLED_NEW_CHARGE.fmx

DOS Command Prompt January 6, 2009

APPEND

(External)

APPEND ;
APPEND [d:]path[;][d:]path[...]
APPEND [/X:on|off][/path:on|off] [/E]

Displays or sets the search path for data files. DOS will search the specified path(s) if the file is not found in the current path.

ASSIGN

(External)

ASSIGN x=y [...] /sta

Redirects disk drive requests to a different drive.

ATTRIB

(External)

ATTRIB [d:][path]filename [/S]
ATTRIB [+R|-R] [+A|-A] [+S|-S] [+H|-H] [d:][path]filename [/S]

Sets or displays the read-only, archive, system, and hidden attributes of a file or directory.

BACKUP

(External)

BACKUP d:[path][filename] d:[/S][/M][/A][/F:(size)] [/P][/D:date] [/T:time] [/L:[path]filename]

Makes a backup copy of one or more files. (In DOS Version 6, this program is stored on the DOS supplemental disk.)

BREAK

(Internal)

BREAK =on|off

Used from the DOS prompt or in a batch file or in the CONFIG.SYS file to set (or display) whether or not DOS should check for a Ctrl + Break key combination.

BUFFERS

(Internal)

BUFFERS=(number),(read-ahead number)

Used in the CONFIG.SYS file to set the number of disk buffers (number) that will be available for use during data input. Also used to set a value for the number of sectors to be read in advance (read-ahead) during data input operations.

CALL

(Internal)

CALL [d:][path]batchfilename [options]

Calls another batch file and then returns to current batch file to continue.

CHCP

(Internal)

CHCP (codepage)

Displays the current code page or changes the code page that DOS will use.

CHDIR

(Internal)

CHDIR (CD) [d:]path
CHDIR (CD)[..]

Displays working (current) directory and/or changes to a different directory.

CHKDSK

(External)

CHKDSK [d:][path][filename] [/F][/V]

Checks a disk and provides a file and memory status report.

CHOICE

(Internal)

CHOICE [/C[:]keys] [/N][/S][/T[:]c,nn] [text]

Used to provide a prompt so that a user can make a choice while a batch program is running.

CLS (Clear Screen)

(Internal)

CLS

Clears (erases) the screen.

COMMAND

(External)

COMMAND [d:][path] [device] [/P][/E:(size)] [/MSG][/Y [/C (command)|/K (command)]

Starts a new version of the DOS command processor (the program that loads the DOS Internal programs).

COMP

(External)

COMP [d:][path][filename] [d:][path][filename] [/A][/C][/D][/L][/N:(number)]

Compares two groups of files to find information that does not match. (See FC command).

COPY

(Internal)

COPY [/Y|-Y] [/A][/B] [d:][path]filename [/A][/B] [d:][path][filename] [/V]
or
COPY [/Y|-Y][/A][/B] [d:][path]filename+[d:][path]filename[...][d:][path][filename] [/V]

Copies and appends files.

COUNTRY

(Internal)

COUNTRY=country code,[,][d:][filename]

Used in the CONFIG.SYS file to tell DOS to use country-specific text conventions during processing.

CTTY

(Internal)

CTTY (device)

Changes the standard I/O (Input/Output) device to an auxiliary device.

DATE

(Internal)

DATE mm-dd-yy

Displays and/or sets the system date.

DBLSPACE

(External)

DBLSPACE / automount=drives
DBLSPACE /chkdsk [/F] [d:]
DBLSPACE /compress d: [/newdrive=host:] [/reserve=size] [/F]
DBLSPACE /create d: [/newdrive=host:] [/reserve=size] [/size=size]
DBLSPACE /defragment [d:] ]/F]
DBLSPACE /delete d:
DBLSPACE /doubleguard=0|1
DBLSPACE /format d:
DBLSPACE [/info] [d:]
DBLSPACE /list
DBLSPACE /mount[=nnn] host: [/newdrive=d:]
DBLSPACE /ratio[=ratio] [d:] [/all]
DBLSPACE /size[=size] [/reserve=size] d:
DBLSPACE /uncompress d:
DBLSPACE /unmount [d:]

A program available with DOS 6.0 that allows you to compress information on a disk.

DEBUG

(External)

DEBUG [pathname] [parameters]

An MS-DOS utility used to test and edit programs.

DEFRAG

(External)

DEFRAG [d:] [/F][/S[:]order] [/B][/skiphigh [/LCD|/BW|/GO] [/H]
DEFRAG [d:] [/V][/B][/skiphigh] [/LCD]|/BW|/GO] [/H]

Optimizes disk performance by reorganizing the files on the disk.

DEL (ERASE)

(Internal)

DEL (ERASE) [d:][path]filename [/P]

Deletes (erases) files from disk.

DELOLDOS

(External)

DELOLDOS [/B]

Deletes all files from previous versions of DOS after a 5.0 or 6.0 installation.

DELTREE

(External)

DELTREE [/Y] [d:]path [d:]path[...]

Deletes (erases) a directory including all files and subdirectories that are in it.

DEVICE

(Internal)

DEVICE=(driver name)

Used in the CONFIG.SYS file to tell DOS which device driver to load.

DEVICEHIGH

(Internal)

DEVICEHIGH=(driver name)

Like DEVICE, DEVICEHIGH is used in the CONFIG.SYS file to tell DOS which device driver software to use for devices; however, this option is used to install the device driver into the upper memory area.

DIR

(Internal)

DIR [d:][path][filename] [/A:(attributes)] [/O:(order)] [/B][/C][/CH][/L][/S][/P][/W]

Displays directory of files and directories stored on disk.

DISKCOMP

(External)

DISKCOMP [d:] [d:][/1][/8]

Compares the contents of two diskettes.

DISKCOPY

(External)

DISKCOPY [d:] [d:][/1][/V][/M]

Makes an exact copy of a diskette.

DOS

(Internal)

DOS=[high|low],[umb|noumb]

Used in the CONFIG.SYS file to specify the memory location for DOS. It is used to load DOS into the upper memory area and to specify whether or not the upper memory blocks will be used.

DOSKEY

(External)

DOSKEY [reinstall] [/bufsize=size][/macros][/history][/insert|/overstrike] [macroname=[text]]

Loads the Doskey program into memory which can be used to recall DOS commands so that you can edit them.

DOSSHELL

(External)

DOSSHELL [/B] [/G:[resolution][n]]|[/T:[resolution][n]]

Initiates the graphic shell program using the specified screen resolution.

DRIVPARM

(Internal)

DRIVPARM= /D:(number) [/C] [/F:(form factor)] [/H:(number)] [/I][ /N][/S:(number)] [/T:(tracks)]

Used in the CONFIG.SYS file to set parameters for a disk drive.

ECHO

(Internal)

ECHO on|off
ECHO (message)

Displays messages or turns on or off the display of commands in a batch file.

EDIT

(External)

EDIT [d:][path]filename [/B][/G][/H][/NOHI]

Starts the MS-DOS editor, a text editor used to create and edit ASCII text files.

EMM386

(External)

EMM386 [on|off|auto] [w=on|off]

Enables or disables EMM386 expanded-memory support on a computer with an 80386 or higher processor.

EXE2BIN

(External)

EXE2BIN [d:][path]filename [d:][path]filename

Converts .EXE (executable) files to binary format.

EXIT

(Internal)

EXIT

Exits a secondary command processor.

EXPAND

(External)

EXPAND [d:][path]filename [[d:][path]filename[ . . .]]

Expands a compressed file.

FASTHELP

(External)

FASTHELP [command][command] /?

Displays a list of DOS commands with a brief explanation of each.

FASTOPEN

(External)

FASTOPEN d:[=n][/X]

Keeps track of the locations of files for fast access.

FC

(External)

FC [/A][/C][/L][/Lb n][/N][/T][/W][number] [d:][path]filename [d:][path]filename

or (for binary comparisons)
FC [/B][/number] [d:][path]filename [d:][path]filename

Displays the differences between two files or sets of files.

FCBS

(Internal)

FCBS=(number)

Used in the CONFIG.SYS file to specify the number of file-control blocks for file sharing.

FDISK

(External)

FDISK [/status]

Prepares a fixed disk to accept DOS files for storage.

FILES

(Internal)

FILES=(number)

Used in the CONFIG.Sys file to specify the maximum number of files that can be open at the same time.

FIND

(External)

FIND [/V][/C][/I][/N] ÒstringÓ [d:][path]filename[...]

Finds and reports the location of a specific string of text characters in one or more files.

FOR

(Internal)

FOR %%(variable) IN (set) DO (command)

or (for interactive processing)
FOR %(variable) IN (set) DO (command)

Performs repeated execution of commands (for both batch processing and interactive processing).

FORMAT

(External)

FORMAT d:[/1][/4][/8][/F:(size)] [/N:(sectors)] [/T:(tracks)][/B|/S][/C][/V:(label)] [/Q][/U][/V]

Formats a disk to accept DOS files.

GOTO

(Internal)

GOTO (label)

Causes unconditional branch to the specified label.

GRAFTABL

(External)

GRAFTABL [(code page)]
GRAFTABL [status]

Loads a table of character data into memory (for use with a color/graphics adapter).

GRAPHICS

(External)

GRAPHICS [printer type][profile] [/B][/R][/LCD][/PB:(id)] [/C][/F][/P(port)]

Provides a way to print contents of a graphics screen display.

HELP

(External)

HELP [command] [/B][/G][/H][/NOHI]

Displays information about a DOS command.

IF

(Internal)

IF [NOT] EXIST filename (command) [parameters]
IF [NOT] (string1)==(string2) (command) [parameters]
IF [NOT] ERRORLEVEL (number) (command) [parameters]

Allows for conditional operations in batch processing.

INCLUDE

(Internal)

INCLUDE= blockname

Used in the CONFIG.SYS file to allow you to use the commands from one CONFIG.SYS block within another.

INSTALL

(Internal)

INSTALL=[d: ][\path]filename [parameters]

Used in the CONFIG.SYS file to load memory-resident programs into conventional memory.

INTERLINK

(External)

INTERLINK [client[:]=[server][:]]

Connects two computers via parallel or serial ports so that the computers can share disks and printer ports.

INTERSVR

(External)

INTERSVR [d:][...][/X=d:][...] [/LPT:[n|address]] [/COM:[n|address]][/baud:rate] [/B][/V]
INTERSVR /RCOPY

Starts the Interlink server.

JOIN

(External)

JOIN d: [d:path]
JOIN d: [/D]

Allows access to the directory structure and files of a drive through a directory on a different drive.

KEYB

(External)

KEYB [xx][,][yyy][,][d:][path]filename [/E][/ID:(number)]

Loads a program that replaces the support program for U. S. keyboards.

LABEL

(External)

LABEL [d:][volume label]

Creates or changes or deletes a volume label for a disk.

LASTDRIVE

(Internal)

LASTDRIVE=(drive letter)

Used in the CONFIG.SYS file to set the maximum number of drives that can be accessed.

LOADFIX

(Internal)

LOADFIX [d:][path]filename [parameters]

Ensures that a program is loaded above the first 64K of conventional memory, and runs the program.

LOADHIGH

(Internal)

LOADHIGH (LH) [d:][path]filename [parameters]

Loads memory resident application into reserved area of memory (between 640K-1M).

MEM

(External)

MEM [/program|/debug|/classify|/free|/module(name)] [/page]

Displays amount of installed and available memory, including extended, expanded, and upper memory.

MEMMAKER

(External)

MEMMAKER [/B][/batch][/session][/swap:d] [/T][/undo][/W:size1,size2]

Starts the MemMaker program, a program that lets you optimize your computer’s memory.

MENUCOLOR

(Internal)

MENUCOLOR=textcolor,[background]

Used in the CONFIG.SYS file to set the colors that will be used by DOS to display text on the screen.

MENUDEFAULT

(Internal)

MENUDEFAULT=blockname, [timeout]

Used in the CONFIG.SYS file to set the startup configuration that will be used by DOS if no key is pressed within the specified timeout period.

MENUITEM

(Internal)

MENUITEM=blockname, [menutext]

Used in the CONFIG.SYS file to create a start-up menu from which you can select a group of CONFIG.SYS commands to be processed upon reboot.

MIRROR

(External)

MIRROR [d:]path [d:] path [...]
MIRROR [d1:][d2:][...] [/T(drive)(files)] [/partn][/U][/1]

Saves disk storage information that can be used to recover accidentally erased files.

MKDIR

(MD) (Internal)

MKDIR (MD) [d:]path

Creates a new subdirectory.

MODE

(External)

MODE n
MODE LPT#[:][n][,][m][,][P][retry]
MODE [n],m[,T]
MODE (displaytype,linetotal)
MODE COMn[:]baud[,][parity][,][databits][,][stopbits][,][retry]
MODE LPT#[:]=COMn [retry]
MODE CON[RATE=(number)][DELAY=(number)]
MODE (device) CODEPAGE PREPARE=(codepage) [d:][path]filename
MODE (device) CODEPAGE PREPARE=(codepage list) [d:][path]filename
MODE (device) CODEPAGE SELECT=(codepage)
MODE (device) CODEPAGE [/STATUS]
MODE (device) CODEPAGE REFRESH

Sets mode of operation for devices or communications.

MORE

(External)

MORE < (filename or command)
(name)|MORE

Sends output to console, one screen at a time.

MOVE

(Internal)

MOVE [/Y|/-Y] [d:][path]filename[,[d:][path]filename[...]] destination

Moves one or more files to the location you specify. Can also be used to rename directories.

MSAV

(External)

MSAV [d:] [/S|/C][/R][/A][/L][/N][/P][/F][/video][/mouse]
MSAV /video

Scans your computer for known viruses.

MSBACKUP

(External)

MSBACKUP [setupfile] [/BW|/LCD|/MDA]

Used to backup or restore one or more files from one disk to another.

MSCDEX

(External)

MSCDEX /D:driver [/D:driver2. . .] [/E][/K][/S][/V][/L:letter] [/M:number]

Used to gain access to CD-ROM drives (new with DOS Version 6).

MSD

(External)

MSD [/B][/I]
MSD [/I] [/F[d:][path]filename [/P[d:][path]filename [/S[d:][path]filename

Provides detailed technical information about your computer.

NLSFUNC

(External)

NLSFUNC [d:][path]filename

Used to load a file with country-specific information.

NUMLOCK

(Internal)

NUMLOCK=on|off

Used in the CONFIG.SYS file to specify the state of the NumLock key.

PATH

(Internal)

PATH;
PATH [d:]path[;][d:]path[...]

Sets or displays directories that will be searched for programs not in the current directory.

PAUSE

(Internal)

PAUSE [comment]

Suspends execution of a batch file until a key is pressed.

POWER

(External)

POWER [adv:max|reg|min]|std|off]

Used to turn power management on and off, report the status of power management, and set levels of power conservation.

PRINT

(External)

PRINT [/B:(buffersize)] [/D:(device)] [/M:(maxtick)] [/Q:(value] [/S:(timeslice)][/U:(busytick)] [/C][/P][/T] [d:][path][filename] [...]

Queues and prints data files.

PROMPT

(Internal)

PROMPT [prompt text] [options]

Changes the DOS command prompt.

RECOVER

(External)

RECOVER [d:][path]filename
RECOVER d:

Resolves sector problems on a file or a disk. (Beginning with DOS Version 6, RECOVER is no longer available ).

REM

(Internal)

REM [comment]

Used in batch files and in the CONFIG.SYS file to insert remarks (that will not be acted on).

RENAME (REN)

(Internal)

RENAME (REN) [d:][path]filename [d:][path]filename

Changes the filename under which a file is stored.

REPLACE

(External)

REPLACE [d:][path]filename [d:][path] [/A][/P][/R][/S][/U][/W]

Replaces stored files with files of the same name from a different storage location.

RESTORE

(External)

RESTORE d: [d:][path]filename [/P][/S][/B:mm-dd-yy] [/A:mm-dd-yy][/E:hh:mm:ss] [/L:hh:mm:ss] [/M][/N][/D]

Restores to standard disk storage format files previously stored using the BACKUP command.

RMDIR (RD)

(Internal)

RMDIR (RD) [d:]path

Removes a subdirectory.

SCANDISK

(External)

SCANDISK [d: [d: . . .]|/all][/checkonly|/autofix[/nosave]|/custom][/surface][/mono][/nosummay]
SCANDISK volume-name[/checkonly|/autofix[/nosave]|/custom][/mono][/nosummary]
SCANDISK /fragment [d:][path]filename
SCANDISK /undo [undo-d:][/mono]

Starts the Microsoft ScanDisk program which is a disk analysis and repair tool used to check a drive for errors and correct any problems that it finds.

SELECT

(External)

SELECT [d:] [d:][path] [country code][keyboard code]

Formats a disk and installs country-specific information and keyboard codes (starting with DOS Version 6, this command is no longer available).

SET

(Internal)

SET (string1)=(string2)

Inserts strings into the command environment. The set values can be used later by programs.

SETVER

(External)

SETVER [d:]:path][filename (number)][/delete][/quiet]

Displays the version table and sets the version of DOS that is reported to programs.

SHARE

(External)

SHARE [/F:space] [/L:locks]

Installs support for file sharing and file locking.

SHELL

(Internal)

SHELL=[d:][path]filename [parameters]

Used in the CONFIG.SYS file to specify the command interpreter that DOS should use.

SHIFT

(Internal)

SHIFT

Increases number of replaceable parameters to more than the standard ten for use in batch files.

SORT

(External)

SORT [/R][/+n] < (filename)
SORT [/R][/+n] > (filename2)

Sorts input and sends it to the screen or to a file.

STACKS

(Internal)

STACKS=(number),(size)

Used in the CONFIG.SYS file to set the number of stack frames and the size of each stack frame.

SUBMENU

(Internal)

SUBMENU=blockname, [menutext]

Used in the CONFIG.SYS file to create a multilevel menu from which you can select start-up options.

SUBST

(External)

SUBST d: d:path
SUBST d: /D

Substitutes a virtual drive letter for a path designation.

SWITCHES

(Internal)

SWITCHES= [/K][/F][/N][/W]

Used in the CONFIG.SYS file to configure DOS in a special way; for example, to tell DOS to emulate different hardware configurations.

SYS

(External)

SYS d:

Transfers the operating system files to another disk.

TIME

(Internal)

TIME hh:mm[:ss][.cc][A|P]

Displays current time setting of system clock and provides a way for you to reset the time.

TREE

(External)

TREE [d:][path] [/A][/F]

Displays directory paths and (optionally) files in each subdirectory.

TYPE

(Internal)

TYPE [d:][path]filename

Displays the contents of a file.

UNDELETE

(External)

UNDELETE [d:][path][filename] [/DT|/DS|/DOS]
UNDELETE [/list|/all|/purge[d:]|/status|/load|/U|/S[d:]|/Td:[-entries]]

Restores files deleted with the DELETE command.

UNFORMAT

(External)

UNFORMAT d: [/J][/L][/test][/partn][/P][/U]

Used to undo the effects of formatting a disk.

VER

(Internal)

VER

Displays the DOS version number.

VERIFY

(Internal)

VERIFY on|off

Turns on the verify mode; the program checks all copying operations to assure that files are copied correctly.

VOL

(Internal)

VOL [d:]

Displays a disk’s volume label.

VSAFE

(External)

VSAFE [/option[+|-]…] [/NE][/NX][Ax|/Cx] [/N][/D][/U]

VSAFE is a memory-resident program that continuously monitors your computer for viruses and displays a warning when it finds one.

XCOPY

(External)

XCOPY [d:][path]filename [d:][path][filename] [/A][/D:(date)] [/E][/M][/P][/S][/V][/W][Y\-Y]
Copies directories, subdirectories, and files.