computer protection with revert
If speed is not a key issue, then build your boot environment on a CD, and set the machine to boot from that. Kinkos and other places do something similar with their rental machines – although as I recall, they forcibly re-image their machines every night from a network based standard image. Try googling for [...]
View Answer
| May 17, 2007 11:53 AM
Application security, configuration, Database, Development, Encryption, Exchange, Instant Messaging, patching, PEN testing, Platform Security, Secure Coding, Security, vulnerability management
If speed is not a key issue, then build your boot environment on a CD, and set the machine to boot from that. Kinkos and other places do something similar with their rental machines – although as I recall, they forcibly re-image their machines every night from a network based standard image. Try googling for [...]
View Answer
| May 17, 2007 11:53 AM
Application security, configuration, Database, Development, Encryption, Exchange, Instant Messaging, patching, PEN testing, Platform Security, Secure Coding, Security, vulnerability management
outer join issue
Old Oracle syntax: SELECT s.name, ______DECODE(lm.name, _____________NULL, ‘The first hop failed’, ___________________DECODE(L.name, __________________________NULL, ‘Second hop failed’, ________________________________’Success’)) status ___FROM Source s, ______LookupMap lm, ______Lookup L ___WHERE s.name=lm.name(+) AND ______lm.lookupName=L.lookupName(+); New Oracle ANSI syntax: SELECT s.name, ______CASE _________WHEN L.name IS NOT NULL THEN ‘Success’ _________WHEN lm.name IS NOT NULL THEN ‘Second hop failed’ _________ELSE ‘First hop [...]
View Answer
| May 10, 2007 1:56 AM
Database, DB2, Oracle
Old Oracle syntax: SELECT s.name, ______DECODE(lm.name, _____________NULL, ‘The first hop failed’, ___________________DECODE(L.name, __________________________NULL, ‘Second hop failed’, ________________________________’Success’)) status ___FROM Source s, ______LookupMap lm, ______Lookup L ___WHERE s.name=lm.name(+) AND ______lm.lookupName=L.lookupName(+); New Oracle ANSI syntax: SELECT s.name, ______CASE _________WHEN L.name IS NOT NULL THEN ‘Success’ _________WHEN lm.name IS NOT NULL THEN ‘Second hop failed’ _________ELSE ‘First hop [...]
View Answer
| May 10, 2007 1:56 AM
Database, DB2, Oracle
Question on LoadAll Subfile.
Hi Rama The short answer is you can’t. The maximum size of a subfile is 9,999 records and that’s imposed by the operating system. The only way to exceed the 9,999 record limit is to use a single page subfile where your program handles the page up and page down. You then need to use [...]
View Answer
| May 7, 2007 5:01 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi Rama The short answer is you can’t. The maximum size of a subfile is 9,999 records and that’s imposed by the operating system. The only way to exceed the 9,999 record limit is to use a single page subfile where your program handles the page up and page down. You then need to use [...]
View Answer
| May 7, 2007 5:01 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Error in a Group of Called Programs
you’ll need to make a copy of the CL that starts at PGMC and continues on.
View Answer
| April 26, 2007 12:32 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
you’ll need to make a copy of the CL that starts at PGMC and continues on.
View Answer
| April 26, 2007 12:32 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
media recovery
best is to create a link betwwen c: and S: Is db in archivelogmode? Was db in restricted mode? Did you enter the recovery command ie “recover database;” to actually recover. Initsid.ora locations need changing. Hard to diagnose further. Keep me in the loop please.
View Answer
| April 10, 2007 3:29 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
best is to create a link betwwen c: and S: Is db in archivelogmode? Was db in restricted mode? Did you enter the recovery command ie “recover database;” to actually recover. Initsid.ora locations need changing. Hard to diagnose further. Keep me in the loop please.
View Answer
| April 10, 2007 3:29 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Optimizing/Indexing to find last transaction
Most important, do you have an index on transaction that consists of item, version and lasttran? You need lasttran included to make the index work. I think that’s the problem. What may be beneficial is to create a work file containing the last transaction of each item in the warehouse. Then create an index on [...]
View Answer
| April 3, 2007 12:56 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
Most important, do you have an index on transaction that consists of item, version and lasttran? You need lasttran included to make the index work. I think that’s the problem. What may be beneficial is to create a work file containing the last transaction of each item in the warehouse. Then create an index on [...]
View Answer
| April 3, 2007 12:56 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
Question on Workfile
Hi Rama There is no difference between a work file and a physical file, a work file is simply a physical file that is used to store temporary data in. It’s like, for example, the difference between a taxi and a car. When I use a “work file” I tend to copy an empty file [...]
View Answer
| March 26, 2007 7:48 AM
AS/400, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi Rama There is no difference between a work file and a physical file, a work file is simply a physical file that is used to store temporary data in. It’s like, for example, the difference between a taxi and a car. When I use a “work file” I tend to copy an empty file [...]
View Answer
| March 26, 2007 7:48 AM
AS/400, DataCenter, DB2 Universal Database, RPG, RPGLE
Sorting out missing out
Here’s the SQL to do the comparison and report the results: SELECT * FROM bigFile MINUS SELECT * FROM smallFile You’re on your own for the MS Excel part. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| March 11, 2007 1:49 AM
Application development, DB2 Universal Database, RPG
Here’s the SQL to do the comparison and report the results: SELECT * FROM bigFile MINUS SELECT * FROM smallFile You’re on your own for the MS Excel part. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| March 11, 2007 1:49 AM
Application development, DB2 Universal Database, RPG
Sorting out missing records.
This is pretty easy to do in SQL. You can start SQL with STRSQL. The command is: SELECT * FROM biggerTable MINUS SELECT * FROM smallerTable — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| March 2, 2007 10:57 AM
DB2 Universal Database
This is pretty easy to do in SQL. You can start SQL with STRSQL. The command is: SELECT * FROM biggerTable MINUS SELECT * FROM smallerTable — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer
| March 2, 2007 10:57 AM
DB2 Universal Database
Updating one record with a field of another record where two other fields match
In DB2 or Oracle, use: UPDATE xref a ___SET id1 = ( ______SELECT b.id2 ______FROM xref b ______WHERE b.projId=’AWPE’ AND _________a.id1=b.id1) ___WHERE projId=’MONDPL’; In MS SQL Server, add AS after xref. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linker.com) 800-315-1174 (+1-949-552-1904)
View Answer
| March 1, 2007 4:52 PM
Data analysis, Database, DB2, Oracle, SQL
In DB2 or Oracle, use: UPDATE xref a ___SET id1 = ( ______SELECT b.id2 ______FROM xref b ______WHERE b.projId=’AWPE’ AND _________a.id1=b.id1) ___WHERE projId=’MONDPL’; In MS SQL Server, add AS after xref. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linker.com) 800-315-1174 (+1-949-552-1904)
View Answer
| March 1, 2007 4:52 PM
Data analysis, Database, DB2, Oracle, SQL
AS400 disk initialize info
Try: DSPHDWRSC TYPE(*STG) OUTPUT(*PRINT) Also jsut doing a WRKDSKSTS would show the new drive installed and working but doesn’t show serial numbers
View Answer
| March 1, 2007 1:55 PM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, RPG, RPGLE, Security
Try: DSPHDWRSC TYPE(*STG) OUTPUT(*PRINT) Also jsut doing a WRKDSKSTS would show the new drive installed and working but doesn’t show serial numbers
View Answer
| March 1, 2007 1:55 PM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, RPG, RPGLE, Security
Comparing 2 files .CSV and getting the missing data using AS400.
if you’re comparing CSV files, and exporting to excel, why bother with the AS400? I’d use Access, it can open a CSV file, and I think it can save query results as excel. I’m pretty sure there’s a construct to find records that are missing from either file, but, I can’t think of it off [...]
View Answer
| February 27, 2007 8:28 AM
DB2 Universal Database, RPG, RPGLE
if you’re comparing CSV files, and exporting to excel, why bother with the AS400? I’d use Access, it can open a CSV file, and I think it can save query results as excel. I’m pretty sure there’s a construct to find records that are missing from either file, but, I can’t think of it off [...]
View Answer
| February 27, 2007 8:28 AM
DB2 Universal Database, RPG, RPGLE
Assessing Security Appliances
Here are some good places to start: www.sans.org reading room www.cisecurity.org (Center for Internet Security) Bob
View Answer
| February 25, 2007 2:08 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
Here are some good places to start: www.sans.org reading room www.cisecurity.org (Center for Internet Security) Bob
View Answer
| February 25, 2007 2:08 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
Lotus Domino Database Structure
Lotus Notes viewa are not same as table structures but you can make them similar to tables. Views are not RBBMS compliant. but these viewa can be exported to tables using odbc connection or Decs or LEI etc..
View Answer
| February 23, 2007 12:12 AM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Lotus Notes viewa are not same as table structures but you can make them similar to tables. Views are not RBBMS compliant. but these viewa can be exported to tables using odbc connection or Decs or LEI etc..
View Answer
| February 23, 2007 12:12 AM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Correlated Subquery – NOT EXIST
Please post the full sql statement so I can determine where to put the not exists clause.
View Answer
| February 21, 2007 3:36 PM
MySQL, SQL, SQL Server
Please post the full sql statement so I can determine where to put the not exists clause.
View Answer
| February 21, 2007 3:36 PM
MySQL, SQL, SQL Server
Windows Scheduling iSeries Data Transfer
I’m probing the deep dark recesses of my increasingly feeble memory, but if it serves me, I think the Windows job scheduler will only run .bat .cmd files.
View Answer
| February 5, 2007 3:54 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
I’m probing the deep dark recesses of my increasingly feeble memory, but if it serves me, I think the Windows job scheduler will only run .bat .cmd files.
View Answer
| February 5, 2007 3:54 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
how to interconnect sql server with remote oracle server
I would recommend creating a Linked Server to your remote Oracle database from your SQL Server database. Look in BOL and the Net for how to. Here are a couple of links… http://www.informit.com/articles/article.asp?p=21644&rl=1 http://www.sqlservercentral.com/columnists/ksonti/anintroductiontolinkedservers.asp
View Answer
| February 5, 2007 11:28 AM
Database, DB2, Oracle, SQL, SQL Server
I would recommend creating a Linked Server to your remote Oracle database from your SQL Server database. Look in BOL and the Net for how to. Here are a couple of links… http://www.informit.com/articles/article.asp?p=21644&rl=1 http://www.sqlservercentral.com/columnists/ksonti/anintroductiontolinkedservers.asp
View Answer
| February 5, 2007 11:28 AM
Database, DB2, Oracle, SQL, SQL Server
Email Delivery Errors
The first log hasn’t any info about the reason for rejecting message. The second one simply points to companyEmailServer has not an MX record in the Name Server’s domain list. I would try to ping companyEmailServer from the sender’s computer and, if successful, then try to open a telnet session from sender’s computer to company’s. [...]
View Answer
| January 27, 2007 6:05 AM
Application security, backdoors, Brightmail, CipherTrust, ClearSwift, Current threats, Database, Encryption, Exchange, Hacking, human factors, Instant Messaging, McAfee, MessageLabs, Postini, Rockliffe, Secure Coding, Security, Spam, SpamAssassin, Spyware, SurfControl, Symantec, TrendMicro, Trojans, Viruses, worms
The first log hasn’t any info about the reason for rejecting message. The second one simply points to companyEmailServer has not an MX record in the Name Server’s domain list. I would try to ping companyEmailServer from the sender’s computer and, if successful, then try to open a telnet session from sender’s computer to company’s. [...]
View Answer
| January 27, 2007 6:05 AM
Application security, backdoors, Brightmail, CipherTrust, ClearSwift, Current threats, Database, Encryption, Exchange, Hacking, human factors, Instant Messaging, McAfee, MessageLabs, Postini, Rockliffe, Secure Coding, Security, Spam, SpamAssassin, Spyware, SurfControl, Symantec, TrendMicro, Trojans, Viruses, worms
How can I find on which files a program has been attached as an external trigger?
The command PRTTRGPGM creates a listing of all the trigger programs in the specified library(ies) and the physical files they are attached to. It also creates a member in the file QSECTRGOLD in library QUSRSYS, with the name of the library scanned by the command. You can query this file to find the information you [...]
View Answer
| January 24, 2007 7:31 AM
Application development, AS/400, DB2 Universal Database, RPGLE
The command PRTTRGPGM creates a listing of all the trigger programs in the specified library(ies) and the physical files they are attached to. It also creates a member in the file QSECTRGOLD in library QUSRSYS, with the name of the library scanned by the command. You can query this file to find the information you [...]
View Answer
| January 24, 2007 7:31 AM
Application development, AS/400, DB2 Universal Database, RPGLE
Windows Server 2003 Web Edition Configuration
Did you remember to publish from your local file system to the website and get NO error reports? as for sql2005 you can use msde instead of full blown sql server. Also ensure that your permissions are set properly
View Answer
| January 21, 2007 7:36 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management
Did you remember to publish from your local file system to the website and get NO error reports? as for sql2005 you can use msde instead of full blown sql server. Also ensure that your permissions are set properly
View Answer
| January 21, 2007 7:36 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management
