We never drop and recreate tables in production. We do regularly in test. Recently we used the ALTER statement to remove a column in a table. The internal or short name was obviously MAX_P00001 because now we only have a MAX_P00002 and a MAX_P00003(using DSPFFD). In test, the table has MAX_P00001 and MAX_P00002 but no…

Hi.. I am Planning to make email automation . mail should have attachment. Attachment is the result of query execution in oracle database .I am getting error ORA 06550 and PLS 00013.Can u help me solve this glitch..Here I Put My PACKAGE.. create table config2 ( TO_ADDRESS VARCHAR2(1000), SMTP_SERVER VARCHAR2(1000), FROM_ADDRESS VARCHAR2(1000), EMAIL_SUBJECT VARCHAR2(1000), EMAIL_TEXT…

How can I bypass the web filters on iron port? I ask because the filters are set wrong and I am constantly blocked for the wrong reasons and it will lock up the web page. E.g., looking up a weather news article and the filter says I am entering a social networking category, wrong. it…

i h 2 tables a and b, all colums of table a have single values but b table’s columns have multiple values when i display result it is as follows– add             product                  qty 25/18 okhla nd               p1                          5 25/18 oklla nd               p2                          6 25/18 oklla nd               p3                          4 but i want like this 25/18         …

How to prevent unauthorize access by Windows XP Pro (SP2) client station to the Volume shadow Copy service of the Server running Server 2003 software. The client station have not been loaded with the “Shadow Copy Client” software, yet they can see the previous version tab when they click on the “Property” button of the…

I want to be able to track the current meetings in my Lotus Notes (LN) calendar. Am I am able to link my meeting entries to Project or Access to track them. I realize there are CRM databases and etc. However, I do not want to re-write the information that is already in my meeting…

reports will not work after I enabled drill downs (v.2.6) Followed directions and enabled drill downs.  Now, reports and drill downs will not work after the day I reset the drill down.  Checked directions and no indication of making changes anywhere other that the configuration menu in surfcontrol UI.  Do I need to reset something…

I have two tables that are joined in a query.  I have a form that points to one of the rows in the table.  I would like to print a single page report for the ONE row.  How do I do that from a multi-row form (with the appropriate row selected) into a MS Access…

Hi I Need to test my site on both IE8 and IE7.Curretly i am planing to test my website by using IE8-developer tools-Swich between ‘Browser Mode :IE7 ,Document Mode: IE7 Standards’ to ‘Browser Mode :IE8 ,Document Mode: IE8 Standards’ .Is this reliable , if not I am going to use my old methods like using…

If a subassembly is setup in JBA system 21, can it “backflush” raw materials from 2 different stockrooms? How? Appreciate the replies

I have an issue seeing how I should do this. The problem I am having is that I am using LotusScript and when I do this function in a field it works and produces how long the between days.  @If(Status=”90″; ((DateS90-DateCreated)/86400)+1; ((@Today-DateCreated)/86400)+1 ) but the problem with this is that is keeps searching and it…

Can anyone tell me what are the storage classes used in RPGLE.?

I want to pull data from Item Descriptions utilizing only certain words within the description; i.e., Vesuvio Beige Hand Board. I want to pull all records with the words “Hand Board” in the description and I’m having trouble getting that to happen.  I’ve tried “is like”, “in” and everything else I can think of, but…

Can any one please tell me how to know the current password of my pl/sql developer which i am using currently? I know my product code and serial Send me the procedure Thanks in advance PSR.COM

For a Cisco product,iIf I have an oversubscribed port or switch, does Weighted Fair Queueing kick in to handle UBRL issues? Assuming I have the correct Supervisor Engine/Netflow combination, how do I configure for this scenario?

I have successfully converted time field to date/time. Now I need to find the total minutes between one field and another but cannot get it to show me any value. I am using DateDiff (‘n’,{@startdatetune}, {@startdatetime}) where n indicates minutes. I should be able to use any field where I have concatenated the date and…

what testing tools are available for data warehouse testing

what testing tools are available for data warehouse testing

I’m trying to transfer the email server of my user to his desired mail server, however upon checking the logs I found three errors and it says, “[strong]Because no enabled connection document specifying replication exists between CCBGSOMS01/CCBG and CCBGCNLMS01/CCBG, Jimmuel Rodrigo/SO/CCBG’s mail files may not be consistent during the Mail File Move process.[/strong]” and another one is…

I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few…