Sql Server Express Edition Replaces MSDE in 8.97 Tools Release

EnterpriseOne 8.97 Tools release replaces MSDE with SSE.There are couple of support and technical reasons behind this move, namely Windows Vista will not support MSDE, Support for MSDE is ending soon[in fact all the SQL server 2000 products] and there are few size limitations with MSDE.
The upcoming Apps release from JDE stable will have SSE at the Deployment Server end.Older apps releases have to be on 8.97 to use the SSE.The existing Data Files from MSDE can be attached to SSE.
Note:Once you have attached to the SSE, the same cannot be reattached to MSDE.
The client Install will have JDESSELocal instance.The SQL Native Client will be used to talk to SSE.

JDE.ini File

Oracle is increasingly focusing on JD Edwards

Oracle is increasingly focusing on JD Edwards through partners in India. Accel Frontline, a member of the OraclePartnerNetwork, is currently implementing JD Edwards applications across a number of midsize and high-growth organizations. These include Altek Beissel Needles (Chennai), Dodla Engineering (Chennai), IJM (India) Infrastructure (Hyderabad), Rotex Automation (Mumbai) and Sankar Sealing Systems (Chennai).

Full Article

Source : ChannelTimes

ISeries/AS400 Table Naming Convention

A system name will be generated if a table, view, alias, or index is created with either:
* A name longer than 10 characters
* A name that contains characters not valid in a system name
The SQL name or its corresponding system name may both be used in SQL statements to access the file once it is created. However, the SQL name is only recognized by DB2 UDB for AS/400 and the system name must be used in other environments.
If the name does not contain special characters and is longer than 10 characters, a 10-character system name will be generated as:
* The first 5 characters of the name
* A 5 digit unique number
If the SQL name contains special characters, the system name is generated as:
* The first 4 characters of the name
* A 4 digit unique number

In addition:
* All special characters are replaced by the underscore (_)
* Any trailing blanks are removed from the name
* The name is delimited by double quotes (") if the delimiters are required for the name to be a valid system name.

Examples
The system name for "??" would be "__0001"
The system name for "longtablename" would be "long0001"
The system name for "LONGTableName" would be LONG0001
The system name for "A b " would be "A_b0001"

SQL ensures the system name is unique by searching the cross reference file. If the name already exists in the cross reference file, the number is incremented until the name is no longer a duplicate.

Basics of Qshell

useful link for IBM QShell:qsh

Verity Loglevel

The VDK_LOGLEVEL environment variable can be used to set the level of information obtained from the mkvdk command.The following are the types of messages possible and the corresponding values.

Fatal 1
Error 2
Warning 4
Status 8
Info 16
Verbose 32
Debug 64

The default value is 15[1+2+4+8],which means it will write Fatal,Error,Warning and Status messages to the vdk log.If you want all the messages to be included then the VDK_ LOGLEVEL should be 127.

Related links

EnterpriseOne appcasts

Listen to the latest developments in Oracle JDEdwards EnterpriseOne via the Oracle podcasts

Server Manager

Server Manager is the latest tool delivered with the recent 8.97 tools release.It is a browser based controller mainly aimed at easing the task of CNC administrators.

Key Feaures
1] It is independent of the Enterprise Server type[i.e machine on which ES is installed].
2] Centralized Management/administration.
Related
A blog on Server Manager: from Developers that wrote it.

8.97 Tools Release GA

• Oracle announced the General Availability of 897 Tools release on Jan 28,2008.
• Press Release
• Systems Management,Reporting and interoperability are the much talked features of this Tools Release.
• 8.97 Tools release can be used in combination with Apps releases 8.9 through 8.12
  

Adding DNS suffixes

Navigate to Start->Settings->Network and Dialup Connections
Select Local Area Connection Properties
Select TCP/IP Properties button
Press Advanced button
Select DNS tab
Now add the required suffixes which will be added to the unqualified names.The order will have importance.