Hello,
I have a table that has several columns including 1 for date and 1 for time HHMMSS.
I would like to get a count of rows grouped by date and within a given time interval of say 5 minutes during a 24 hour period. Can somebody help?
Something like this
Count, Date, Time
1...
Hi,
I have a property variable which contains a pipe seperated String of file names. I want to take that list of file names and create an array of File objects.
My code is
[code]
String xsls = properties.getProperty("xsls");
File [] xslfiles = xsls.split("\\|");
[code]
I get the following...
Hello, I am trying to streamline my code to make use of a loop to populate a NameValuePair array. My code compiles..but I get a run-time error:
Exception in thread "main" java.lang.NullPointerException
at lawsonUtil.NVPFromXML(lawsonUtil.java:34)
at...
Hi..I need to write a java program that will "iterate" over a set of files (*.xml) in a given directory. For each file I need to open it up and readin the xml contents...do some processing on it and close then rename or delete the file.
I am wondering if I should use an Enumeration or Iterator...
I have the following simple program:
import com.lawson.lawsec.authen.httpconnection.*;
import com.lawson.lawsec.authen.*;
import org.apache.commons.httpclient.*;
public class LawsonLogin2
{
public static void main(String[] args)
{
String vUrl =...
I installed the PerfSevletApp.ear.
When I try to invoke using the following call
http://portal.test.mycompany.com/wasPerfTool/servlet/perfservlet?server=server1&username=myuser&password=mypasswd&connector=SOAP
I receive the following error:
<?xml version="1.0" encoding="UTF-8" ?>
- <!--...
Hello,
We are on 6.0.2.19 ND.
I am trying to configure a monitoring tool for WebSphere.
It's asking me to provide the SOAP_CONNECTOR_ADDRESS port
and the HTTP TRANSPORT port?
How can I determine this info? We have global security turned on. I see where server1 is using 8880 as the soap...
I need to automate FTP over SSL connection. Not sure if anybody can recommend any Perl modules to help accomplish this?
BTW...this is very different from FTP over SSH.
Thanks.
Hello,
I would like to use sftp to transfer files...I am wondering if it works anything like regular ftp redirect a file of commands to execute:
sftp -vn <ftpcommand
where ftpcommand is text file of commands to execute:
open my.site.com
user myuser mypasswd
put myfile
quit
Thanks.
I have the following script..but it does not seem to work just the way I want it:
#!/bin/bash
find . -type f | while read fname; do
grep '[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}' "$fname"
#grep '\([0-9]\{1,3\}\.\)\{3\}[0-9]\{1,3\}' "$fname"
if [ $? -eq 0 ]; then
echo "The...
Hello,
How do I assign a value to a property in a Task in VBSCRIPT?
I have a dts package. The final tasks is an "analysis services processing task" that I named "processCube".
I would like to programmatically set the property "ProcessOption" of the task.
v_process_option = 1
Dim oPKG
Set...
Hello,
I have a MS-OLAP Cube. I want to get rid of the data in it and start from scratch. So I deleted all my data from the all dimension tables and fact table. Then I try to perform "Incremental Update", "Refresh Data", and "Rebuild" and they all fail with:
<code>
Processing error [Source...
I grabbed a snippet of code from this forum to send e-mail from a DTS package via ActiveX script. The script is shown below.
I have a package with one task (ActiveX Script task). When I execute the package I get the following error but yet I receive the e-mail just fine:
Error:
The task...
I need to create a table with rows for everyday of the year for the next 3 years. Example columns is shown below:
T_Date : 03/01/2008
DayofYear: 61
WeekOfYear: 09
Quarter: 02
DayofWeek: Sat
This is for a time dimension for a DataWarehouse. Can anybody point me to a sample function...
I am very new to this and this question is more regarding design then anything else so I am sure there is more then one right answer..
I have a dimension table.
I have a fact table.
I have a staging table.
A new record shows up in the staging table. I want to add that table to fact table but...
Hi.
I am trying to figure what DTS tasks to use to accomplish the below scenario.
1. Query table/column A.JOBID where A.STATUS = PUSHED.
2. For each A.JOBID from query 1 set A.STATUS = PULLING.
3. Query oracle table B and insert into sql table C each record where B.STATUS = PULLING.
4...
I have an array of arrays (3x6) and I pass it to a subroutine to loop thru and insert into a table. But when I pass the array to the sub the array seems to become a (1x6).
@rowarr = ( [ "ROLE", "ROLE TEST1", "HRSiteAdmin", "HR1", "Admin", 0 ],
[ "ROLE", "ROLE TEST2"...
I am testing the following at the solaris command prompt and getting the below error. What am I doing wrong?
$ allfiles="fred.c alex.c"
$ echo $allfiles
fred.c alex.c
$ alljobs=${allfiles/c/o}
ksh: alljobs=${allfiles/c/o}: bad substitution
Any help is appreciated.
Hi Folks.
We have a "hung thread" situation on our applications. I am using jython to dump threads per some instructions I read on the IBM Website:
jvm = AdminControl.completeObjectName('type=JVM,process=server1,*')
AdminControl.invoke(jvm, 'dumpThreads')
I have no idea where the output...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.