Search results for query: *

I am new to Webfocus. Can I add aggregate column in the Master file? Eg. Sum(tablename.columname) I would like to use the same column in multiple reports. Thanks

I have SQL for updating table. The SQL has derived table. The SQL works in Queryman but doesn't work in mainframe BTEQ. Appreciate your help. Thanks

${ORACLE_HOME}/bin/sqlplus -s $USER_DW_ADMIN/$PWD_DW_ADMIN << EOF set colsep '' set pagesize 0 set heading off set feedback off set echo off set arraysize 5000 set termout off SET WRAP OFF spool $DW_LST/temp11 while read plant TS_date junk do [ "$plant" = "Plant" ] && continue...

Hi, I would like to create SQL statements from flat file. Flat file has follwing values: Plant Date AB1 2005-10-10 AC1 2004-10-10 Shell script has following variables: set type01 = "xxx" SQL should be: Insert into qa set date01 = 2005-10-10(from flat file), plant01=AB1(from flat...

How to encrypt database password in the perl script? Currently I have database password stored in the perl script, and CGI scripts uses this perl script to connect to database. I would like to encrypt the database password in separate file. I have shell script to encrypt password file. I have...

How to encrypt database password in the perl script? Currently I have database password stored in the perl script, and CGI scripts uses this perl script to connect to database. I would like to encrypt the database password in separate file. I have shell script to encrypt password file. I have...

I have following ASP page to restart IIS web server. <% Dim ows Dim ret set oWS=server.createobject(&quot;WScript.shell&quot;) ret=oWS.Run(&quot;F:\wrestart.bat&quot;) if(ret<>0) then response.write(&quot;error <br>&quot;) end if %> The wrestart.bat file is working fine. But when I try...

Hi, I am trying to calculate values in VBA. The following code should get value from &quot;A&quot; variable and calculate for variable &quot;B&quot; = ( A + 10). Some how it is not working. Can you please help me? Thanks, Dave Sub Try() Dim strYearVals As String Dim bodvrYear As...

Hi, How to calculate 6 sigma in BO Report? Thanks, Dave

Hi, I am very new to XML. Can you please let me know, How can we add/delete XML file records using JSP in Unix machine? Thanks, Dave

Hi, I am very new to JSP. Can you please let me know, How can we add/delete XML file records using JSP in Unix machine? Thanks, Dave

Is there any website where we can find example for complicated SQL. Like for travel ticket for Airlines Here is the Example.. From New York to Detroit to Chicago to Florida... I have data in following pattern in the table: TicketNno Place Date&Time xx1 NewYork...

Is there any website where we can find example for complicated SQL. Like for travel ticket for Airlines Here is the Example.. From New York to Detroit to Chicago to Florida... I have data in following pattern in the table: TicketNno Place Date&Time xx1 NewYork...

Hi, I am very new to informatica. How to get more information for informatica like educational software or documentation for it. Thanks,

Hi, I am very new to Mainframe. Can someone please help, what is differance between as/400 and OS/400. Is os400 is better then os/390. Thanks,

Hi, I have Windows XP with SBC yahoo DSL. I tried to install VPN 5.2.3 on the system. I was able to connect to internet/intranet but some website like yahoo.com or hotmail.com has problem to access e-mail. And when I uninstall VPN the websites work fine. Please help. thanks,

Hi, I have a question. Appereciate your help. SQL needs distinct count with different column as per case statement conditions. Table data : Source Col1 Col2 Col3 Plant1 x1 Plant1 x2 Plant2 x1 y1 Plant2 x1 y1 Plant2 x2 y2 SQL ???????? Select Source...

Hi, How can we avoid password expire of 90 days. How to Change password by SQL or to automate the process of reset the password. Thanks,

Hi, We have Activity log table, When job finish it will insert a row with how many rows inserted with table name. ****** Activty_log********* Table Inserted Total_row tab1 100 ????? Is it possible to create trigger(After Insert) that will take that table name and query with (Select *...

Hi, Is it possible to record list of users logged in and save them with timestamp in text file in sun solaris system. thanks,