DSXchange

prabu

Thank you for all your response! Yes, the DSJ.ME is valid in an afterjob routine. But I am still not get any rowcount back, even when I tried to write the job report out to a file using the statement below: ReportText =DSMakeJobReport(JobHandle,2,"CRLF") I can see the job/stages/links nam...

prabu

Hi, Thanks for reply.I could not get the solution. Thanks & Regards, -- sudhakar please try the following in the same order 1) type which tnsping 2) if 1 returns the path then cd to the path returned by 1 else find . -name tnsping 2>/dev/null cd the path retured from above end if 3) tnsping SER...

prabu

Hi DS folks, please let me know if there is a way available to persist the input file generated by Row generator.i believe it uses a pipe stream to keep the generated records! 2) i can't find the bad file + param file generated, i see only control + log file even when there is a failure[is it the de...

prabu

chulett wrote:A quick search turned this post up.

Thanks chulett, this helps!

prabu

Hi, I have a partitioned Oracle table that partitioned by the monthly. How can I read only one partition via the Parallel Job. Best Regards MAli You need not specify the partition , if you have a "where clause" that confines your data within the partition. Say you have a month partition a...

prabu

Hello DataStage Folks,
Does DataStage Ver 7.5x2 compatible with Visual C++ 2005.[ i know it works with VC 2003]. anyone ever tried??

please let me know

thanks,
Prabu

prabu

Hai, My file is in /cust/ris/dev/data/rwinbound/pos2/unfid_errors(Unix) verify that POS data has been processed for the file date and terminal id. File Name : ras.dltx.postrn. 20060719 .070547. 00002973 Date : 20060719 terminal id: 00002973--How to get the date and terminal id for each filename fro...

prabu

adams06 wrote:Hi,

how to replace a leading prefix with 'xyz'

Thanks in advance

Please do the follwing steps in the same order

1) Open your online datastage help
2)Goto Search
type

Code: Select all

string functions

try to use one or more of the functions listed to achieve your result

prabu

How does one go about cleaning out every last shred of evidence of a DS job? I'm sleuthing an abend and I'd like to recreate this job from the ground up with no evidence it ever existed. Thank you This is supposed to be done by DataStage[or any other tool for that matter, say oracle] to clear up th...

prabu

it should be a C++ compiler, AFAIK

prabu

psriva wrote:I am trying to read an input file that has been compressed with gzip and I am trying to uncompress it with the expand stage.
My problem is specifying the schema for the input file. How should the schema be?

use gunzip and see the structure[hope you have column header]

prabu

And if that is the case, then the Funnel with a Sort is your best option. May I know why you are suggesting this? May be I am missing something... only reason i can think of is , you may get a satisfaction of using more stages in your job [if you think for some more time, you may also 'feel' remove...

prabu

assuming col5 is ora key and col2 is funnel key ora_Col1 Col3 Col4 *Col5 (from the Oracle table) ora_col1 col3 ds_Col1 col4 *Col2 (used for the lookup reference) col5 Col3 col2 [don't take this from bottom left] Col4 hope this helps!

prabu

Hello, I Each input Dataset have the structure: Col1 Col2 (used for the lookup reference) Col3 Col4 And my Output Dataset is Col1 Col3 Col4 Col5 (from the Oracle table) I don't have the RCP activated but my Dataset is created as: Col1 Col2 Col3 Col4 Col5 As my Load job is a generic one for which I ...

prabu

psv wrote:When I try to import plusgin meta definitions it gives error for all listed plugins.
error - unable to initialize plugin.
Please help

which is your source ??

DSXchange

Search found 142 matches

Persist Generated File Infile..Row_Generator

Re: Oracle Partitioned Table

Visual C++ 2005!

Re: Extracting Date part from File Name

Re: replace

Re: Complete cleanout of a job

Re: schema record definition for a zipped input file

Re: Dataset with a different structure

Re: unable to initialize plugin