Daily Question and Answer Update for Jan 13, 2009

New questions and answers have been added to the community for the following
tags:
- CRM
- Database
- DataCenter
- Development
- Linux
- Microsoft Windows
- Networking
- Security
- Storage
Continue the conversation. Answer or discuss a question and earn Knowledge
Points.

-----------------------------------------------------------------------
CRM UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5551306/4946246/1

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5551306/4946246/2

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5551306/4946246/3

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5551306/4946246/4

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5551307/4946246/5
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
How to check the existence of a Column in SQL Server 2000?

ANSWER from Msi77:
Try this:

[CODE]select sysobjects.name
from syscolumns
left join sysobjects on sysobjects.id = syscolumns.id
where syscolumns.name = 'FieldName'
and sysobjects.type = 'U'
order by 1[/CODE]

Or this
[CODE]SELECT name
FROM syscolumns
WHERE name = 'YourColumnName' and ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551308/4946246/6

-----------------------------------------------------------------------
DATABASE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5551306/4946246/7

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5551306/4946246/8

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5551306/4946246/9

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5551306/4946246/10

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5551307/4946246/11
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Replacing motherboard

DISCUSSION from PC32Mech:
Hello.
If you don't want lose your data, I recommend to disconnect immediately the
hard disk.

If a chip take fire it can damage your hard disk.
The internal power supply could have been ruined

When you connect the new motherboard, still the hard disk disconnected up to
seeing on your scree...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5551330/4946246/12

-----------------------------------------------------------------------
DATACENTER UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Data Center related Questions and Answers
http://go.techtarget.com/r/5551309/4946246/13
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Data Area Lock issue in RPG ILE

DISCUSSION from Rajeshece:
Its not possibe
We need to dlcobj or
kill the session or
need to remove the lock using out keyword

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5551310/4946246/14

-----------------------------------------------------------------------
UPDATED ANSWER on:
how do you code a table in rpg

ANSWER from Philpl1jb:
Hello Simobam

It sounds like you want to create a table on the AS/400 -- i series

This isn't usually done in RPG - that's a programming language.

There are two ways to create a table on this system

In SQL -- from a prompt line on the green screen - STRSQL

Use SQL create table command....

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551311/4946246/15

-----------------------------------------------------------------------
NEW DISCUSSION on:
How can I find out , where I am in Intereactive mode or Batch mode in RPG ?

DISCUSSION from Philpl1jb:
Use the QUSRJOBI API to determine if RPGLE program is Batch or Interactive

http://www.as400pro.com/tipView/category/RPG/key/266/

Phil

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5551312/4946246/16

-----------------------------------------------------------------------
NEW DISCUSSION on:
delete records in a RPG flat file

DISCUSSION from Philpl1jb:
Delete if you like.
You need an RPG program to read the records and delete those you don't want.
Open it with the U/update code use DELETE command
Or use the SQL delete ...

But I'm too thick for your discussion
Why use DSPLNK and not use it to get a current picuture of all the .txt files
in...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5551313/4946246/17

-----------------------------------------------------------------------
DEVELOPMENT UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Development related Questions and Answers
http://go.techtarget.com/r/5551332/4946246/18
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Edit data in an Access Form

QUESTION from Lydytunes:
I have done this before, but cant get it to work in my new database. I have
created a form that is based off a query in my database. I want my users to be
able to type data into one of the fields on my form and the table driving the
query will update with what they type. Every form I've created w...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551325/4946246/19

-----------------------------------------------------------------------
NEW ANSWER on:
mailbox rights Outlook 2003

ANSWER from N8dog89:
Have you checked the Security tab on the Mailbox Store (ServerName) in
question?

Run Exchange System Manager, then click on Administrative Groups, then First
Administrative Groups, then servers, then (ServerName), then First Storage
Group, then Mailbox Store (ServerName)

Right click on the Mai...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551333/4946246/20

-----------------------------------------------------------------------
NEW ANSWER on:
Cisco 5510 firewall configuration

ANSWER from JimmyIT:
Try one of these [A
href="http://www.cisco.com/en/US/products/ps6120/products_installation_and_confi
guration_guides_list.html"]guides from Cisco [/A]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551334/4946246/21

-----------------------------------------------------------------------
NEW ANSWER on:
SMTP protocol error occurred

ANSWER from Technochic:
Check your event logs for SMTP errors and post the exact errors. If you have
not installed SP2 and all rollups and exchange updates install these as soon as
possible. How long ago did the problem begin? What changes were made before the
problem began?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551335/4946246/22

-----------------------------------------------------------------------
NEW ANSWER on:
Microsoft Exchange Server 2003 installation and configuration

ANSWER from Technochic:
If this is going to be a single exchange mailbox server with no front end
server then it will receive mail from your gateway. No receive connector is
required as it is with Exchange 2007 because in Exchange 2007 the mail server
roles are different and function differently. With Exchange 2007 a hub t...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551336/4946246/23

-----------------------------------------------------------------------
LINUX UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5551306/4946246/24

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5551306/4946246/25

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5551306/4946246/26

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5551306/4946246/27

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5551307/4946246/28
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Can I use a Linksys BEFSR41 as a hub connected to a Linksys WRT150N?

ANSWER from Pjb0222:
Yes you should be able to do this. Just make sure to disable the DHCP Server.

Do not use the WAN port (Internet connection) for cross connecting between the
old router and your new router. Use just the four (4) switch ports. Depending
on the system you may need a crossover cable or adapter to c...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551317/4946246/29

-----------------------------------------------------------------------
NEW QUESTION on:
WAN design and implementation

QUESTION from Labnuke99:
Well a LAN is a wired network (an ethernet cable runs to each device on the
network; generally pretty reliable).

WAN is a wireless network (each device on the network has a wireless card and
gets the internet that way).

If your 7 sites are physically in different locations (as in not the same ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551318/4946246/30

-----------------------------------------------------------------------
MICROSOFT WINDOWS UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5551306/4946246/31

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5551306/4946246/32

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5551306/4946246/33

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5551306/4946246/34

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5551307/4946246/35
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
How to configure Yahoo email to work in Outlook 2003

DISCUSSION from Carlosdl:
Yes, you need Yahoo Mail plus in order to be able to use the pop access.

There is an open source program called [A
href="http://ypopsemail.com/"]YPOPs![/A], which provides pop and smtp access to
yahoo, but I have not tried it yet.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5551319/4946246/36

-----------------------------------------------------------------------
NETWORKING UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5551306/4946246/37

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5551306/4946246/38

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5551306/4946246/39

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5551306/4946246/40

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5551307/4946246/41
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Job Scheduling

DISCUSSION from Gilly400:
Hi,

You can also use WRKJOBSCDE to work with and add scheduled jobs.

Regards,

Martin Gilbert.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5551320/4946246/42

-----------------------------------------------------------------------
NEW QUESTION on:
How can I transfer an ASCII file with negative numbers to my iSeries

QUESTION from Philpl1jb:
Is this a flat file or a deliminated file.
You may need to create an RPG program --
Character strings with leading / trailing - are handled properly at conversion
using %DEC

Phil

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551321/4946246/43

-----------------------------------------------------------------------
UPDATED ANSWER on:
Can I use a Linksys BEFSR41 as a hub connected to a Linksys WRT150N?

ANSWER from Pjb0222:
Yes you should be able to do this. Just make sure to disable the DHCP Server.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551317/4946246/44

-----------------------------------------------------------------------
NEW QUESTION on:
WAN design and implementation

QUESTION from Labnuke99:
Well a LAN is a wired network (an ethernet cable runs to each device on the
network; generally pretty reliable).

WAN is a wireless network (each device on the network has a wireless card and
gets the internet that way).

If your 7 sites are physically in different locations (as in not the same ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551318/4946246/45

-----------------------------------------------------------------------
SECURITY UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Security related Questions and Answers
http://go.techtarget.com/r/5551322/4946246/46
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
Iseries Queries.

ANSWER from Gilly400:

Hi,

I assume you've got this scheduled using the WRKJOBSCDE on the AS400. If you
only want the job to run MON-FRI you should change the SCDDAY parameter on the
job schedule entry to be (*MON *TUE *WED *THU *FRI) instead of *ALL.

Regards,

Martin Gilbert.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551323/4946246/47

-----------------------------------------------------------------------
UPDATED ANSWER on:
Adding a password to a SQL Server 2005 database

ANSWER from Mrdenny:
Here is a [A
href="http://www.sqlservercentral.com/articles/Administering/beginningsqlserverl
oginsandusers/1460/"]good article.[/A]. You will have to register to read it,
but registration is free.

-------

Each login which is setup within the SQL Server has its own password. The
login is what ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551324/4946246/48

-----------------------------------------------------------------------
NEW QUESTION on:
Edit data in an Access Form

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551325/4946246/49

-----------------------------------------------------------------------
NEW QUESTION on:
WAN design and implementation

QUESTION from Labnuke99:
Well a LAN is a wired network (an ethernet cable runs to each device on the
network; generally pretty reliable).

WAN is a wireless network (each device on the network has a wireless card and
gets the internet that way).

If your 7 sites are physically in different locations (as in not the same ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551318/4946246/50

-----------------------------------------------------------------------
STORAGE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Storage related Questions and Answers
http://go.techtarget.com/r/5551326/4946246/51
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
lotusnotes to oracle

QUESTION from Oraclelotu:
i have a field (date)i want to insert date(field) in oracle table .i
used"+doc.date(0)+"but date is not inserted in oracle table .
how can it possible .pls suggest me.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551327/4946246/52

-----------------------------------------------------------------------
UPDATED ANSWER on:
Free online practice exercises on SQL/Oracle.

ANSWER from Msi77:
A Gentle Introduction to SQL
http://sqlzoo.net/

SQLCourse - Interactive Online SQL Training for Beginners
http://sqlcourse.com/

SQLCourse2 - Advanced Online SQL Training
http://sqlcourse2.com/

SQL Exercises - Online SQL (DML) Training
[A href="http://www.sql-ex.ru/"]www.sql-ex.ru/[/A]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551328/4946246/53

-----------------------------------------------------------------------
NEW ANSWER on:
Bulk Collect loop and Cursor Loop

ANSWER from Carlosdl:
"PL/SQL sends SQL statements such as DML and queries to the SQL engine for
execution, and SQL returns the results to PL/SQL. You can minimize the
performance overhead of this communication between PL/SQL and SQL by using the
PL/SQL features that are known collectively as bulk SQL.

The FORALL stat...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5551329/4946246/54

-----------------------------------------------------------------------
NEW QUESTION on:
WAN design and implementation

QUESTION from Labnuke99:
Well a LAN is a wired network (an ethernet cable runs to each device on the
network; generally pretty reliable).

WAN is a wireless network (each device on the network has a wireless card and
gets the internet that way).

If your 7 sites are physically in different locations (as in not the same ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5551318/4946246/55

-----------------------------------------------------------------------
-----------------------------------------------------------------------

UNSUBSCRIBE
You are receiving this e-mail because you subscribed to tag e-mail alerts
on ITKnowledgeExchange.com.

To unsubscribe from tag e-mail alerts click the link below to
"Edit My Account". Go to the Newsletter Preferences section and un-check
tags you no longer wish to receive e-mail alerts on and click "Save".
http://ITKnowledgeExchange.techtarget.com/settings/account/

To unsubscribe from all tag e-mail alerts, click the link below:
http://ITKnowledgeExchange.techtarget.com/unsubscribe?email=sekhargreen@gmail.com&key=41289&tag=1

-----------------------------------------------------------------------

ABOUT THIS E-NEWSLETTER
This e-newsletter is published by ITKnowledgeExchange.com, a
targeted Web site from TechTarget, The IT Media ROI Experts and
events company.