Search found 47 matches

by aaikat
Tue Jun 06, 2006 6:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting count of records passed through a link
Replies: 17
Views: 9560

Actually my requirement is to write the record count (processed by a link) into a table from within the job.How to do it then?
by aaikat
Tue Jun 06, 2006 6:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting count of records passed through a link
Replies: 17
Views: 9560

Thanks all of you.The code is working properly to get the count associated with a link.
My next question is 'Will I be able to use this server routine in a parallel job'. If 'yes', how?
by aaikat
Mon Jun 05, 2006 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting count of records passed through a link
Replies: 17
Views: 9560

I faced error while compiling a server routine code with the function DSGetLinkInfo. ( I tried for server routine as I didn't find place to write code in case of Parallel routine).I wrote the following code : hJob = DSAttachJob(JobName, DSJ.ERRFATAL) If NOT(hJob) Then Call DSLogFatal("Job Attac...
by aaikat
Mon Jun 05, 2006 6:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting count of records passed through a link
Replies: 17
Views: 9560

Hi ArndW,
As you have said we can use transform stage variables @INROWNUM and @OUTROWNUM.But they are incremental in nature.If I want to get the total count of records processed by a Transformer stage what shd I do.
by aaikat
Mon Jun 05, 2006 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting count of records passed through a link
Replies: 17
Views: 9560

Getting count of records passed through a link

I am a new user of DSEE.Please advise me how should I get the count of records processed by a link. I dont find any built-in routine for that.
by aaikat
Wed May 24, 2006 7:23 am
Forum: IBM QualityStage
Topic: Problem in running QSRT Manager
Replies: 1
Views: 1784

Problem in running QSRT Manager

While trying to import QualityStage Metadata into DataStage through QualityStage Metadata Plug-In,I faced the following error : 'QSRT OPEN JOB FAILED: PLEASE CHECK QSRTMNGR LOG' Error log QualityStageMDImport.log is created with size 0. Is this due to failure in QSRT Manager ? When I went to check w...
by aaikat
Tue May 23, 2006 1:16 am
Forum: IBM QualityStage
Topic: Installing QualityStage plug-in in DataStage
Replies: 5
Views: 3332

I am now able to install QS plug-in in DS.But the problem I am facing is when I edit the QualityStage stage in DS,then in 'Stage' tab, I dont find any 'Server','Job' tab (have 'General','NLS' only).But without those tabs I wont be able to map the stage to a QS job. I have my QS,DS client,server inst...
by aaikat
Thu May 18, 2006 12:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing QualityStage Plug-In in DataStage
Replies: 2
Views: 1711

Installing QualityStage Plug-In in DataStage

I want to install QualityStage plug-in in DataStage.After running Package Installer for QualityStage what step I need to do next.I can not find any QualityStage stage in DataStage Palette.Should I do 'Register Plug-In'.In that case what is the name of the .dll file for QualityStage.
by aaikat
Thu May 04, 2006 5:01 am
Forum: IBM QualityStage
Topic: Installing QualityStage plug-in in DataStage
Replies: 5
Views: 3332

Installing QualityStage plug-in in DataStage

I am new to both DataStage & Qualitystage. I have ran DataStage Package Installer for QualityStage.The installer ran fine and did not give any error.Now when I open DataStage Designer ( for designing a server job) I dont find any 'QualityStage' stage in Processing Palette. Please advise me how t...
by aaikat
Wed May 03, 2006 11:30 pm
Forum: IBM QualityStage
Topic: Using ODBC Connections in QS
Replies: 3
Views: 2400

How to create an ODBC connection in AIX server

Will someone please help me to create ODBC connections in AIX server.What are the files that we need to modify and with what information.
by aaikat
Fri Apr 21, 2006 4:48 am
Forum: IBM QualityStage
Topic: Using ODBC Connections in QS
Replies: 3
Views: 2400

Using ODBC Connections in QS

I have my QS Designer locally(Win) whereas the QS server(Unix) is remote.

Now in order to import a Data File Definition(or any other work) using ODBC where the DSN should be configured in QS Client or QS Server.
by aaikat
Mon Apr 17, 2006 5:55 am
Forum: IBM QualityStage
Topic: Problem with QualityStage Reports Generator
Replies: 2
Views: 2052

Problem with QualityStage Reports Generator

I am a new user of QS.I am facing problem in 'Report Generator'(File -> Reports) in QS.I have specified Reports Database : C:\Ascential\QualityStageDesigner75\Reports.mdb It is giving error :- 'Unrecognized database format 'C:\Ascential\QualityStageDesigner75\Reports.mdb' I didn't install Access.I h...
by aaikat
Tue Mar 28, 2006 4:32 am
Forum: IBM QualityStage
Topic: QualityStage Problem while working with Excel file as input
Replies: 1
Views: 1774

QualityStage Problem while working with Excel file as input

I am a new user of QualityStage.I have created an ODBC DSN for Excel file with multiple worksheets.Now I opened : File -> Import -> Datafile Definition -> From ODBC File Definition In 'Import Data Definition From ODBC' window, I choose the DSN,Database,Database codepage.Now when I press 'Connect' I ...
by aaikat
Tue Mar 28, 2006 12:42 am
Forum: IBM QualityStage
Topic: QualityStage Problems
Replies: 0
Views: 1292

QualityStage Problems

I am a new user of QualityStage(QS).I have the following questions :- 1.Can I use an Excel file in QS as input file ? In that case if I use a 'Format Convert' stage (to make the input file fixed width) what will be the delimiter? 2.I am facing problem in 'Report Generator'(File -> Reports) in QS.I h...
by aaikat
Mon Mar 27, 2006 11:59 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: ProfileStage
Replies: 3
Views: 3460

ProfileStage

I checked that the xls workbook path has been correctly mentioned while creating the ODBC.Yet in 'Load Database Meta Data' dialog box after choosing the ODBC DSN when I go for 'Select Tables', the list does not show all the sheets as tables.Only a few of them are shown. What could be the reason,plz ...