DSXchange

Hi Everybody,

I am facing too much Server load on my Unix server while running DS jobs.

What will be the reason taking around 80-90% server CPU?

I appreciate if any body gives a quick solution for this.

Thanks and Regards
Shiv

Dear All,

Can any body tell whether i can Install full version of IBM Information Server 8.0 (Both client and Server) on Windows XP professional edition ?

I would like to test a trial version on Windows XP pc, can i do this?

Thanks
Shiv

THis doesnt work sir, since my ranges are dynamic and based on last two fields. last but one field is starting range and last field is ending no. now when u generate the nos with those two fields as ranges u will get all other fields dumplicated.... So hope you are clear now. Thanks Shiv search for ...

Urgent means i need it badly sir,
hope you help me, i have monday a delivery for this.
So pls help me.
Thanks
shiv

ray.wurlod wrote:We don't do "urgent". You have been posting here long enough to know that.

Hi All Need a urgent help. I have records like this 33979|21014589|1536|06/13/2005|V00020|2.1|400|400|050903010013534923|050903010013535322 Now i want it like this 33979|21014589|1536|06/13/2005|V00020|2.1|400|400|050903010013534923 33979|21014589|1536|06/13/2005|V00020|2.1|400|400|05090301001353492...

Hi All, I have a Date comparison problem. I need to get the answer like this Date()-PaymentDate=No of days. PaymentDate format is like this 2005-09-21 16:11:04 How to do the comparion and get the no of days? Can any body help me? One more case is that if PaymentDate value 20050929 then how can it be...

Hi thanks for your reply. Well i am using vb script because, in database table name is like "SUM_<Date>" so for each cycle one table will be created. So now i cant findout directly which is the latest table. so i am just passing the <date> from datastage to this vb script where as in vbs f...

Hi That was nice script, Can you help me in getting a script for Windows one? Thanks Shiv There are a lot of jobs here. GenHtmlFromSql is a job which will turn a SQL statement into a html page and email it to you. GenHtmlFromSqlDriver is a driver job for the above job. It will give you a list of SQL...

Hi, I want to know whether any body has a script for Email, My requirements are to send a mail after each job runs for success and failure as well. Mail should contains the whole job list and which job is run successfully and which is not and if it ran then how many no of rows loaded how many reject...

Thanks for your kind reply. See i have a vbs file in which i wrote some VB script, of which it has some SQL statements which just creates a snap shot of a huge table in to a text file. Now this VB Scripe has to be run by passing the parameter into it. Parameter is Date, when i pass this date in quer...

Hi All, I have a problem in my job, i am trying run Before job Sub Routine: like this #ControlFileDirectory#/sv_extract_GEN.vbs /param1:#extractdate# MOU in my vbs file i am dumping a table to a flat plain text file. When i run my job, it just hangs out there, doesnot create any file. Can any body t...

chulett wrote:What kind of "routine"? If you mean stored procedure, then you can call it in the before- or after-sql tab of the OCI stage.

Its a Datastage Routine.

Hi,
I have a routine where i will develop dynamic table names.
i need to call this routine from OCI stage, and dump the data to a flat file.
Can i know how can i do this?

Kindly reply back to me.
Thanks
Shiv

Hi, Having problem in Agregator stage while running my job, I have two fields, one is customer_node_ID and other one is charge. i am doing sum(charge) grouping by customer_node_id. when i run this job i am getting an error stating "Invalid Number" kindly give me some input why i am getting...

I have a query like this my OCI stage. select * from table where TO_CHAR(sysdate, 'YYYY-MM-DD HH24:MI:SS') between TO_CHAR(b.effective_start_date, 'YYYY-MM-DD HH24:MI:SS') and TO_CHAR(b.effective_end_date, 'YYYY-MM-DD HH24:MI:SS') when i run this query i am getting an error like this , OCI DATE conv...