DSXchange

Craig, Thanks - We tried that option to reduce teh transaction size to 5 or 1. However, still the problem persists. >>Sounds like your job is locking itself out - is that what you meant by "waiting for resources"? Yes >>And are you saying you have three output links all writing to the same...

Hi - Problem in DS Server job (connecting to a database table)- I've a stream of data as input (consider a data file for simplicity). No of records 10-500. Based on conditional check in a transformer - I hv 2 outputs each writing to a table X in Oracle database using odbc stage. Further I hv another...

Hi - We hv a data migration project using only the DS Server components. In this, we would receive the source data in UTF8 character set, which also contains some special characters/non-ascii charcters as well - we need to handle them. Solution attempted- For this purpose, we changed the DS project ...

Thanks all.
Esplly Rama solution above helped..

Hi - Job Description- I have a simple job which is reading a sequential file, passing the data to a Xformer and then preparing a Hash file as output. Error- On running the job I'm receiving the following FATAL error - DSD.UVOpen "<Hash File Name>" is already in your VOC file as a file defi...

Thanks - I mean server routines... On importing a datastage project dsx -with all the jobs and routines involved - we would need to compile all of them (jobs and routines) right. In that case I am wanting to know - - what is the way to compile all the routines (multiple) ...in an easy way? Thanks, N...

Hi -

Is there a way to compile multiple routines at one shot!?
(similar to the multiple job compile menu option - available in the DataStage client)

I'm using DataStage version 7.1.

Thanks,
Nitin

Ray, The junk characters coming out (in ascii file) are something like "^Z". Essentially, I require to read a UTF8 file as source file in one of my job. Subsequently in the process, all intermittent / temporary staging I want to stick to ascii character set. And I need to generate a final ...

Hi, I am facing problem with UTF8 character set. I have an input file in UTF8 character set - on reading that file using sequential stage I define the NLS as UTF-8. There is a join and a transformer stage in my designed job. Finally am taking a sequential file as output in ASCII mode. The file obtai...

Hi,

Am getting the folloing error on execution of a job - the source file and file path and there accordingly and the file can be read as well.

Error
"main_program: Fatal Error: this APT_Locator is invalid: Empty locator"

Any pointers to this problem?

Thanks,
Nitin

Thanks Ray..

Then...What is your suggestion on the simplest way to convert a field of data type double to a data type decimal of specific precision say decimal(22,2)

Rgds,
Nitin

Hi, In the aggregator stage, is there an option that the o/p of summation of a decimal field is produced in the desired decimal format - without any leading / trailing zeroes. From example -(i/p and o/p from aggregator based on a key) I/P --fld1 values--100,200, 300 O/P--Sum(fld)1---600.0 [and NOT 0...

yes - am making sure that the output fields are allowed to take NULL values so that passing NULL values should not be a problem.

Hi, Regarding the Lookup or Join Stage - Consider the scenario where records in driver file DO NOT find a match (reject) based on the Key in the lookup/ reference file. Then the fields which the lookup/ Join was supposed to pick up from the lookup file / reference file would be populated as blank or...

How do I make sure that the DataStage installation is done with NLS?
(I do not have admin rights on the DataStage installed on our server.)

Thanks
Nitin

[/img][/list][/list]