Access SQL Server 2003 database from ISeries
use upper search-for with iseries sql server search in all search400, you will find many tips, first look at “Accessing MS SQL Server database from the iSeries “
View Answer
| November 9, 2005 1:39 AM
Access, AS/400, Database, DB2 Universal Database, RPG, SQL Server
use upper search-for with iseries sql server search in all search400, you will find many tips, first look at “Accessing MS SQL Server database from the iSeries “
View Answer
| November 9, 2005 1:39 AM
Access, AS/400, Database, DB2 Universal Database, RPG, SQL Server
making CHGOBJOWN faster
add an ALCOBJ before your CHGOBJOWN, this will trap the object lock immediatly.
View Answer
| November 9, 2005 1:28 AM
AS/400, DB2 Universal Database
add an ALCOBJ before your CHGOBJOWN, this will trap the object lock immediatly.
View Answer
| November 9, 2005 1:28 AM
AS/400, DB2 Universal Database
DATE, TIME and TIMESTAMP fields in the database files
do the work with sql, it natively support these kind of fields. steps : -1- try the sql orders with STRSQL -2- embbed sql in your code. if necessary, doc is in “DB2 UDB for iSeries SQL Programming with Host Languages” or “DB2 Universal Database for iSeries SQL Reference”, IBM books
View Answer
| November 7, 2005 7:40 AM
AS/400, Database, DB2 Universal Database, RPG
do the work with sql, it natively support these kind of fields. steps : -1- try the sql orders with STRSQL -2- embbed sql in your code. if necessary, doc is in “DB2 UDB for iSeries SQL Programming with Host Languages” or “DB2 Universal Database for iSeries SQL Reference”, IBM books
View Answer
| November 7, 2005 7:40 AM
AS/400, Database, DB2 Universal Database, RPG
regarding vpn
Hi Nirmala, Linux already has a free software, which will help you to configure the l2tp VPN connection. You can refer the following URL for more details: http://www.jacco2.dds.nl/networking/freeswan-l2tp.html Please let me know if you need any clarification. Lov Mani
View Answer
| November 7, 2005 2:43 AM
Access control, Application security, Biometrics, Browsers, Database, Digital certificates, Encryption, Exchange, filtering, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Microprocessors, Network security, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, SSL/TLS, VoIP, VPN, Web security, Wireless
Hi Nirmala, Linux already has a free software, which will help you to configure the l2tp VPN connection. You can refer the following URL for more details: http://www.jacco2.dds.nl/networking/freeswan-l2tp.html Please let me know if you need any clarification. Lov Mani
View Answer
| November 7, 2005 2:43 AM
Access control, Application security, Biometrics, Browsers, Database, Digital certificates, Encryption, Exchange, filtering, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Microprocessors, Network security, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, SSL/TLS, VoIP, VPN, Web security, Wireless
Company policies on protecting personal data
2 options really… 1….everything in house behind firewall non-encrypted while any laptop or remote connections via vpn to be encrypted… 2….encrypt everything the one thing that holds people back from total encryption is the time it takes to decrypt info in order to view/manipulate. the easiest method to employ is to set rules in email [...]
View Answer
| November 6, 2005 11:50 PM
Application security, Biometrics, Compliance, CRM, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Identity & Access Management, Instant Messaging, Laws, Policies, provisioning, Regulations, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, standards
2 options really… 1….everything in house behind firewall non-encrypted while any laptop or remote connections via vpn to be encrypted… 2….encrypt everything the one thing that holds people back from total encryption is the time it takes to decrypt info in order to view/manipulate. the easiest method to employ is to set rules in email [...]
View Answer
| November 6, 2005 11:50 PM
Application security, Biometrics, Compliance, CRM, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Identity & Access Management, Instant Messaging, Laws, Policies, provisioning, Regulations, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, standards
Copying Windows RAS Properties to Different Users
Technically you should use distinct user id’s and RAS connections.. Why keep the same password as the departing employee?? Wouldn’t your passwords have expired a long time ago before she is scheduled to return?? You may have to add the temp as a member for the ‘full time employees’ group meaninng the group that the [...]
View Answer
| November 5, 2005 12:55 AM
Application security, Database, DataCenter, Desktops, Encryption, Exchange, Instant Messaging, Management, Microsoft Windows, OS, Secure Coding, Security, Servers, SQL Server, Tech support
Technically you should use distinct user id’s and RAS connections.. Why keep the same password as the departing employee?? Wouldn’t your passwords have expired a long time ago before she is scheduled to return?? You may have to add the temp as a member for the ‘full time employees’ group meaninng the group that the [...]
View Answer
| November 5, 2005 12:55 AM
Application security, Database, DataCenter, Desktops, Encryption, Exchange, Instant Messaging, Management, Microsoft Windows, OS, Secure Coding, Security, Servers, SQL Server, Tech support
CUM PTF V5R3
In the past any ptfs required to be installed before a cum, were included on the cum CDs and the steps to install them were part of the instructions for the cum package. If you don’t have them already, you should be able to find the cum instructions for the current cum by ordering ptf [...]
View Answer
| November 3, 2005 1:34 PM
AS/400, Database
In the past any ptfs required to be installed before a cum, were included on the cum CDs and the steps to install them were part of the instructions for the cum package. If you don’t have them already, you should be able to find the cum instructions for the current cum by ordering ptf [...]
View Answer
| November 3, 2005 1:34 PM
AS/400, Database
Accessing Oracle database on Linux from Mainframe
Do you have Oracle s/w for installing the client on the linux box? That’s the first step. Then is configuring the tnsnames.ora, listener.ora and sqlnet.ora files (help is around, such as http://www.orafaq.com/faqnet.htm). (I assume you ping the box, if not, you should get that to work first) You will need to ask for the database [...]
View Answer
| November 3, 2005 11:14 AM
AS/400, DB2 Universal Database, Linux, Oracle
Do you have Oracle s/w for installing the client on the linux box? That’s the first step. Then is configuring the tnsnames.ora, listener.ora and sqlnet.ora files (help is around, such as http://www.orafaq.com/faqnet.htm). (I assume you ping the box, if not, you should get that to work first) You will need to ask for the database [...]
View Answer
| November 3, 2005 11:14 AM
AS/400, DB2 Universal Database, Linux, Oracle
Reading a file twice in CL
Hi, If you have V5.3 installed on your AS/400 then you declare the same file twice. I have not yet tried on older versions. Best of luck.
View Answer
| November 3, 2005 8:35 AM
AS/400, Database, DB2 Universal Database, RPG
Hi, If you have V5.3 installed on your AS/400 then you declare the same file twice. I have not yet tried on older versions. Best of luck.
View Answer
| November 3, 2005 8:35 AM
AS/400, Database, DB2 Universal Database, RPG
Is java better thab vb ?
It’s best to know both. Working as a consultant, I’ve had to write a lot of code, and rescue a lot of projects in trouble. I’ve never had to fix bad Java code; just add to it. VB code often involves a lot of fixing. Either way, I have to know both. Where’s the future? [...]
View Answer
| November 3, 2005 2:44 AM
Database, DB2, Oracle
It’s best to know both. Working as a consultant, I’ve had to write a lot of code, and rescue a lot of projects in trouble. I’ve never had to fix bad Java code; just add to it. VB code often involves a lot of fixing. Either way, I have to know both. Where’s the future? [...]
View Answer
| November 3, 2005 2:44 AM
Database, DB2, Oracle
STRQMQRY not sum up the right total
sample ?
View Answer
| November 2, 2005 3:49 PM
AS/400, Database, DB2 Universal Database, RPG
sample ?
View Answer
| November 2, 2005 3:49 PM
AS/400, Database, DB2 Universal Database, RPG
Question about a frequently changing column as primary key
There’s not a hard cutoff line. Having a changing element as a part of a key, primary or not, causes work. The only question is, are you better off indexed or not. You can work out the theory for weeks, or you can try the application with and without the index. Note also that having [...]
View Answer
| November 2, 2005 1:45 PM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
There’s not a hard cutoff line. Having a changing element as a part of a key, primary or not, causes work. The only question is, are you better off indexed or not. You can work out the theory for weeks, or you can try the application with and without the index. Note also that having [...]
View Answer
| November 2, 2005 1:45 PM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
Seeking SAP SEM configuration help
Deer all I have with success used the configuration guide from ConDaus.com many times – I do not know If it will help in this situation. Kind regards Erik Olsen
View Answer
| November 2, 2005 4:17 AM
Access control, Application security, backdoors, Basis, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, SAP, SAP careers, Secure Coding, Security, Security Program Management, Security tokens, SEM, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Upgrades / implementations, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Deer all I have with success used the configuration guide from ConDaus.com many times – I do not know If it will help in this situation. Kind regards Erik Olsen
View Answer
| November 2, 2005 4:17 AM
Access control, Application security, backdoors, Basis, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Development, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, SAP, SAP careers, Secure Coding, Security, Security Program Management, Security tokens, SEM, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Upgrades / implementations, Viruses, VPN, vulnerability management, Web security, Wireless, worms
E-mail filtering service thinks zip file is infected with W32/Bagle virus
I have not heard of a contaminated ‘zipping’ program that added a virus during compression. I have had repeated occasions where a ‘filtering’ service declared all ‘zips’ to be viruses, default settings of block .exe .vbs .zip are not uncommon because they are easy. To actually investigate the content of a ‘zip’ file is not [...]
View Answer
| November 1, 2005 4:02 PM
Application security, backdoors, Current threats, Database, Encryption, Exchange, Hacking, human factors, Instant Messaging, Secure Coding, Security, Spyware, Trojans, Viruses, worms
I have not heard of a contaminated ‘zipping’ program that added a virus during compression. I have had repeated occasions where a ‘filtering’ service declared all ‘zips’ to be viruses, default settings of block .exe .vbs .zip are not uncommon because they are easy. To actually investigate the content of a ‘zip’ file is not [...]
View Answer
| November 1, 2005 4:02 PM
Application security, backdoors, Current threats, Database, Encryption, Exchange, Hacking, human factors, Instant Messaging, Secure Coding, Security, Spyware, Trojans, Viruses, worms
Time Management
Hi, This is part of TCP/IP, is called SNTP (Simple Network Time Protocol), conforms to RFC2030, uses 2 system values QTIMADJ and QTIMZON and I think you will have to configure it through iSeries Navigator. Best of luck.
View Answer
| November 1, 2005 10:07 AM
Database
Hi, This is part of TCP/IP, is called SNTP (Simple Network Time Protocol), conforms to RFC2030, uses 2 system values QTIMADJ and QTIMZON and I think you will have to configure it through iSeries Navigator. Best of luck.
View Answer
| November 1, 2005 10:07 AM
Database
Trouble Editing Data on iSeries from Web Application
I know this is simple and is most likely not the solution but have you checked the profiles authority to the objects?
View Answer
| October 31, 2005 3:17 AM
AS/400, DB2 Universal Database, Java
I know this is simple and is most likely not the solution but have you checked the profiles authority to the objects?
View Answer
| October 31, 2005 3:17 AM
AS/400, DB2 Universal Database, Java
Maximum program per trigger event
You can call another program from your orginal trigger program. Up to 6 triggers per PF.
View Answer
| October 31, 2005 2:58 AM
AS/400, DB2 Universal Database, RPG
You can call another program from your orginal trigger program. Up to 6 triggers per PF.
View Answer
| October 31, 2005 2:58 AM
AS/400, DB2 Universal Database, RPG
Synchronizing expired merge subscription database with publication database
Hi, Can u specify which database severs ur trying to merge.
View Answer
| October 28, 2005 2:32 PM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
Hi, Can u specify which database severs ur trying to merge.
View Answer
| October 28, 2005 2:32 PM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Updates from SearchSQLServer.com staff
Penetration Testing.
Ok, this is NOT a commercial spam – but, I do this sort of thing for a living. If you want free, then download and run nessus yourself. (www.nessus.org) If you want the experienced professional evaluation of the results, they you’re going to have to pay someone. I’m not trying to give you a hard [...]
View Answer
| October 28, 2005 1:58 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Systems management software, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Ok, this is NOT a commercial spam – but, I do this sort of thing for a living. If you want free, then download and run nessus yourself. (www.nessus.org) If you want the experienced professional evaluation of the results, they you’re going to have to pay someone. I’m not trying to give you a hard [...]
View Answer
| October 28, 2005 1:58 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Systems management software, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Oracle Import
Hi, Can you try compiling following 2 files logging as sys. $ORACLE_HOME/rdbms/admin/dbmsread.sql $ORACLE_HOME/rdbms/admin/prvtread.plb I am not very sure that this will work. But it may resolve the issue. Regards.
View Answer
| October 28, 2005 12:40 AM
Database, DB2, Oracle
Hi, Can you try compiling following 2 files logging as sys. $ORACLE_HOME/rdbms/admin/dbmsread.sql $ORACLE_HOME/rdbms/admin/prvtread.plb I am not very sure that this will work. But it may resolve the issue. Regards.
View Answer
| October 28, 2005 12:40 AM
Database, DB2, Oracle
