Impact Analysis – None Answered till now
We use Pathfinder from Hawkeye Information systems to do the research you just described. Not only does it find every query and program that use the file but it also builds a mass compile list for you to recompile the programs that are affected by the file change.
View Answer
| October 27, 2005 7:21 AM
AS/400, Database, DB2 Universal Database, RPG
We use Pathfinder from Hawkeye Information systems to do the research you just described. Not only does it find every query and program that use the file but it also builds a mass compile list for you to recompile the programs that are affected by the file change.
View Answer
| October 27, 2005 7:21 AM
AS/400, Database, DB2 Universal Database, RPG
Recommendations on protecting a Microsoft 2003 server with Lotus Domino 6.5
Hi Jim!! Refer to the following article: http://www-128.ibm.com/developerworks/lotus/library/dominowebserver-security/ It will help you. Regards, Nilesh Roy.
View Answer
| October 27, 2005 1:32 AM
Application security, Compliance, CRM, Database, Desktops, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Windows, Network security, OS, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, VPN, Wireless
Hi Jim!! Refer to the following article: http://www-128.ibm.com/developerworks/lotus/library/dominowebserver-security/ It will help you. Regards, Nilesh Roy.
View Answer
| October 27, 2005 1:32 AM
Application security, Compliance, CRM, Database, Desktops, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Windows, Network security, OS, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, SQL Server, VPN, Wireless
Error executing stored procedure calling a CL that run an STRQMQRY
The problem is described by reason code ’4′. Message SQL0752 in QSQLMSG lists the reason codes. “4 — The connection is locked by another invocation of Interactive SQL, or there is a level mismatch between the Interactive SQL product and the DB2 UDB for iSeries product.” You already have a connection to the database in [...]
View Answer
| October 26, 2005 1:11 PM
AS/400, Database, DB2 Universal Database, RPG
The problem is described by reason code ’4′. Message SQL0752 in QSQLMSG lists the reason codes. “4 — The connection is locked by another invocation of Interactive SQL, or there is a level mismatch between the Interactive SQL product and the DB2 UDB for iSeries product.” You already have a connection to the database in [...]
View Answer
| October 26, 2005 1:11 PM
AS/400, Database, DB2 Universal Database, RPG
Oracle Import to Linux
1). FTP this file from your VAX system to your Linux system. 2). Make sure you copy it as a BINARY file. 3). Run the import function from Linux. It shoud be that easy….
View Answer
| October 26, 2005 7:48 AM
Database, DB2, Oracle
1). FTP this file from your VAX system to your Linux system. 2). Make sure you copy it as a BINARY file. 3). Run the import function from Linux. It shoud be that easy….
View Answer
| October 26, 2005 7:48 AM
Database, DB2, Oracle
Knowing the number of rows in a cursor
I doubt that such a function exists. What you want is essentially to retrieve count(*) in place of your selected column(s). Oracle appears to handle cursors very efficiently by not bringing back all of the rows at once, but only as it needs more to satisfy a fetch request. You could could do that “SELECT [...]
View Answer
| October 25, 2005 7:00 PM
Database, DB2, Oracle, SQL, Windows
I doubt that such a function exists. What you want is essentially to retrieve count(*) in place of your selected column(s). Oracle appears to handle cursors very efficiently by not bringing back all of the rows at once, but only as it needs more to satisfy a fetch request. You could could do that “SELECT [...]
View Answer
| October 25, 2005 7:00 PM
Database, DB2, Oracle, SQL, Windows
Deleting duplicate rows based on timestamps
I’ll show you the SQL to do this below, but first I have to explain something. During any two separate SQL executions, each timestamp will have a different value. For example, (examples shown in DB2 syntax): INSERT INTO xxx VALUES(CURRENT TIMESTAMP); INSERT INTO xxx VALUES(CURRENT TIMESTAMP); The two timestamps will have different values, even if [...]
View Answer
| October 22, 2005 3:55 PM
Database, DB2, Oracle, SQL
I’ll show you the SQL to do this below, but first I have to explain something. During any two separate SQL executions, each timestamp will have a different value. For example, (examples shown in DB2 syntax): INSERT INTO xxx VALUES(CURRENT TIMESTAMP); INSERT INTO xxx VALUES(CURRENT TIMESTAMP); The two timestamps will have different values, even if [...]
View Answer
| October 22, 2005 3:55 PM
Database, DB2, Oracle, SQL
MMAIL
I had same kind of errors due to CCSID. MMAIL is tested in a 400 with QCCSID=037 & jobccsid 037 As I have a 400 with qccsid = 65535 & jobccsid = 297 (ie from France), I had the @ char transformed to a (classic conversion error). So I have found one configuration where message [...]
View Answer
| October 21, 2005 10:09 AM
AS/400, Database, DB2 Universal Database, RPG
I had same kind of errors due to CCSID. MMAIL is tested in a 400 with QCCSID=037 & jobccsid 037 As I have a 400 with qccsid = 65535 & jobccsid = 297 (ie from France), I had the @ char transformed to a (classic conversion error). So I have found one configuration where message [...]
View Answer
| October 21, 2005 10:09 AM
AS/400, Database, DB2 Universal Database, RPG
Database cleanup
Hi, Not sure about q1. But for q2 and q3, you can easily check the same using TOAD. It provides you the TAB (Referentials / Used By) for the dependant and referenced objects. You would be able to get information on procedures / packages written in database. But with reference to the proc*c or c++, [...]
View Answer
| October 21, 2005 4:06 AM
Database, DB2, Oracle
Hi, Not sure about q1. But for q2 and q3, you can easily check the same using TOAD. It provides you the TAB (Referentials / Used By) for the dependant and referenced objects. You would be able to get information on procedures / packages written in database. But with reference to the proc*c or c++, [...]
View Answer
| October 21, 2005 4:06 AM
Database, DB2, Oracle
Windows 2000 / 2003 Server Log Management
There are many tools out there, but the one I use primarily and is free is Microsoft’s Log Parser 2.2. It supports text, CSV, and XML formats. There’s some training curve involved, but that’s the same with any other tool. You can download it from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&DisplayLang=en
View Answer
| October 19, 2005 11:39 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Data mining/analysis, Database, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, Microsoft Office, Microsoft Windows, Network security, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Remote management, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, standards, Trojans, Updates from SearchCRM.com staff, Updates from SearchWindowsSecurity.com staff, Viruses, VPN, vulnerability management, Web security, Wireless, worms
There are many tools out there, but the one I use primarily and is free is Microsoft’s Log Parser 2.2. It supports text, CSV, and XML formats. There’s some training curve involved, but that’s the same with any other tool. You can download it from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=890cd06b-abf8-4c25-91b2-f8d975cf8c07&DisplayLang=en
View Answer
| October 19, 2005 11:39 AM
Access, Access control, Application security, backdoors, Biometrics, Browsers, Career development, Compliance, configuration, CRM, Current threats, Data analysis, Data mining/analysis, Database, Desktop management applications, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Laws, Management, Microsoft Office, Microsoft Windows, Network security, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Regulations, Remote management, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, standards, Trojans, Updates from SearchCRM.com staff, Updates from SearchWindowsSecurity.com staff, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Need help with max function within a left outer join
What does your SQL statement look like ?
View Answer
| October 19, 2005 5:17 AM
Database, DB2, Oracle, SQL
What does your SQL statement look like ?
View Answer
| October 19, 2005 5:17 AM
Database, DB2, Oracle, SQL
SOS: Configuring Microsoft IIS6 to receive emails addressed to postmaster@69.59.X.X and / or abuse@69.59.X.X
iis6.0 does not have inbound mail support.. BUT since iis6.0 is part of Server 2003 you can add pop service (pop3) to accept incoming mail.. this is where the MX records come into play with DNS and AD
View Answer
| October 18, 2005 7:13 PM
Application security, Database, DataCenter, Encryption, Exchange, Instant Messaging, Secure Coding
iis6.0 does not have inbound mail support.. BUT since iis6.0 is part of Server 2003 you can add pop service (pop3) to accept incoming mail.. this is where the MX records come into play with DNS and AD
View Answer
| October 18, 2005 7:13 PM
Application security, Database, DataCenter, Encryption, Exchange, Instant Messaging, Secure Coding
how can an application disable/enable a user account in active directory??
fingerprint reader is simply one type of authentication method, like a password/passphrase, a digital token or CAC card. It’s not the reader which will enable or disable the account, but the directory services behind the authentication process (Actve Directory, RADIUS, NDS, etc…). Look at your authentication server to perform some action upon login via biometric [...]
View Answer
| October 18, 2005 8:43 AM
Application security, Biometrics, Compliance, CRM, Database, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, OS, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, SQL Server, VPN, Wireless
fingerprint reader is simply one type of authentication method, like a password/passphrase, a digital token or CAC card. It’s not the reader which will enable or disable the account, but the directory services behind the authentication process (Actve Directory, RADIUS, NDS, etc…). Look at your authentication server to perform some action upon login via biometric [...]
View Answer
| October 18, 2005 8:43 AM
Application security, Biometrics, Compliance, CRM, Database, Desktops, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Windows, Network security, OS, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, SQL Server, VPN, Wireless
Upgrade OS from V4R5 to V5R2 and SQL stopped working
In 2003 we migrated from V4R5 to V5R2 and had SQL “issues”. Can’t remember exactly what they were but I have an archived email that says the solution was the deletion of QGPL/QZDAPKG *SQLPKG. Once deleted this is recreated by QUSER and solves the problem – whatever that may be. Apologies for the rather un-specific [...]
View Answer
| October 18, 2005 8:01 AM
Database, DB2 Universal Database
In 2003 we migrated from V4R5 to V5R2 and had SQL “issues”. Can’t remember exactly what they were but I have an archived email that says the solution was the deletion of QGPL/QZDAPKG *SQLPKG. Once deleted this is recreated by QUSER and solves the problem – whatever that may be. Apologies for the rather un-specific [...]
View Answer
| October 18, 2005 8:01 AM
Database, DB2 Universal Database
user password auditing
I have never used this utility but I would say you are approaching the problem from the wrong angle. I would change the Password Requirement to Strong Password requirements. More that 8 Charectors and Must use numbers and Capitals (special charectors like !@#$%^&*() never hurt either.) I would then Set all accounts to require a [...]
View Answer
| October 14, 2005 10:24 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, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
I have never used this utility but I would say you are approaching the problem from the wrong angle. I would change the Password Requirement to Strong Password requirements. More that 8 Charectors and Must use numbers and Capitals (special charectors like !@#$%^&*() never hurt either.) I would then Set all accounts to require a [...]
View Answer
| October 14, 2005 10:24 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, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
HTTP File upload/post Blocking
The answer is complex. You can use checkpoint NGX firewall with web intellegence license and block attachments by not allowing the POST method.You can also use the microsoft RMS product and specify strict controls over sensetive files – that will prevent users from send those files via email. You can also install controlguard on you [...]
View Answer
| October 14, 2005 8:47 AM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network protocols, Network security, Networking, Secure Coding, Security, Servers, Spyware, SSL/TLS, TCP, Trojans, Viruses, VPN, Web security, Wireless, worms
The answer is complex. You can use checkpoint NGX firewall with web intellegence license and block attachments by not allowing the POST method.You can also use the microsoft RMS product and specify strict controls over sensetive files – that will prevent users from send those files via email. You can also install controlguard on you [...]
View Answer
| October 14, 2005 8:47 AM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network protocols, Network security, Networking, Secure Coding, Security, Servers, Spyware, SSL/TLS, TCP, Trojans, Viruses, VPN, Web security, Wireless, worms
ODBC Request from iSeries to Excel
Your DSN is OK: manual sql is successfull. it seems to me that you can adapt your problem : If you type in manual sql select * from … then clic on the button to show the graphic assistant, does MSQuery shows the file fields ? if yes, you have force msquery to help you [...]
View Answer
| October 14, 2005 1:48 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL
Your DSN is OK: manual sql is successfull. it seems to me that you can adapt your problem : If you type in manual sql select * from … then clic on the button to show the graphic assistant, does MSQuery shows the file fields ? if yes, you have force msquery to help you [...]
View Answer
| October 14, 2005 1:48 AM
AS/400, DB2 Universal Database, Microsoft Office, SQL
AS/400 – iSeries SQL Update of on table with values from another joined table
Use: EXEC SQL UPDATE firstTable ft SET (firstField, secondField) = ( SELECT st.stuffForFirstField, st.stuffForSecondField FROM secondTable st WHERE ft.linkage=st.linkage) WHERE firstTableCriteria=:yourCriteriaHere; /s/Sheldon Linker
View Answer
| May 11, 2013 11:01 PM
AS/400, DB2 Universal Database, SQL
Use: EXEC SQL UPDATE firstTable ft SET (firstField, secondField) = ( SELECT st.stuffForFirstField, st.stuffForSecondField FROM secondTable st WHERE ft.linkage=st.linkage) WHERE firstTableCriteria=:yourCriteriaHere; /s/Sheldon Linker
View Answer
| May 11, 2013 11:01 PM
AS/400, DB2 Universal Database, SQL
AS400 SQL
Think you need to be a little more specific. Are you a user or a programmer. What would be using the sql in.
View Answer
| October 13, 2005 8:39 AM
DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Think you need to be a little more specific. Are you a user or a programmer. What would be using the sql in.
View Answer
| October 13, 2005 8:39 AM
DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Oracle Hash Partitioning.
The point of hash partitioning is: let the DB manage the partitioning automatically. Therefore I do not think you can control it. If you want to control partitions within each range, you could use range-list partitioning, as long as you are working at least with Oracle 9iR2, which is recommendable for data warehousing, anyway.
View Answer
| October 13, 2005 3:07 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
The point of hash partitioning is: let the DB manage the partitioning automatically. Therefore I do not think you can control it. If you want to control partitions within each range, you could use range-list partitioning, as long as you are working at least with Oracle 9iR2, which is recommendable for data warehousing, anyway.
View Answer
| October 13, 2005 3:07 AM
Business Objects, Data analysis, Data warehousing applications, Database, DB2, Oracle, Windows
Which SAP training should I go after to get a good job in Canada?
hai iam rajkuma from India As per ur Q? Abt ASAP that i know If ur technical student u should select ABAP bec’use that was based on Technical subject If u wanna a Fuctionality there will be a SD-> Sales & Distrubution ,MM-> Material Management Like wise 28 modules r there ………….. Bec’se ur B.sc [...]
View Answer
| October 12, 2005 5:12 AM
Career development, IT careers, SAP careers
hai iam rajkuma from India As per ur Q? Abt ASAP that i know If ur technical student u should select ABAP bec’use that was based on Technical subject If u wanna a Fuctionality there will be a SD-> Sales & Distrubution ,MM-> Material Management Like wise 28 modules r there ………….. Bec’se ur B.sc [...]
View Answer
| October 12, 2005 5:12 AM
Career development, IT careers, SAP careers
