DSXchange

env | grep NLS return nothing

If I run the dsenv file at DSHOME

couldn't set locale correctly
couldn't set locale correctly

just installed Datastage 7.5 with NLS. Restarted the server getting the error

couldn't set locale correctly
couldn't set locale correctly

need help.

thanks in advance

Hi we are going to set up New servers for Datastage and will migrate the Projects to the new server in near future. we are now planning for the space requirement for SCRATCH Disk. as SCRATCH Disk is used for sorting operation by Datastage Engine, we will definitely consider the Volume of Data to be ...

sorry Ray.I got disconnected thrice while trying to post this.Didn't know if it got posted. Since I dont have admin rights I cann't check the environment. As i know , that datastage returns a default character for a char field for lookup mismatch in a non -nullable field ,can you tell me where this ...

input is A.txt file(10 records) which has fileld C1,C2...char field... ref i/p is B.txt(7 records) which has field C1,C3...char filed.... lookup has continue condition.... In lookup the o/p fields are C1,C2,C3 now o/p of lookup is 10....(7 records matching...if lookup condition is reject it rejects ...

Hi In the Production system The Parallel Jobs were pointing to Oracle9i Database, Now The Database upgrade is happening to Oracle 10g. So Can you please advice/suggest on the points: 1. Whether any sort of Changes required to the Job (mostly not)? 2. Whether any changes required to use the advance f...

I am writting to the file not reading from it...

ray.wurlod wrote:It makes no difference when reading. The data themselves are not padded. Declare it as VarChar(6) or make sure that the data field always contains precisely six characters.

I have the padded char as space in the sequential file. I am receiving the same error still: Sequential_File_27: Error when checking operator: Unable to initialize the exporter. Sequential_File_27: Error when checking operator: "record_length=fixed" (no length given) and record field forma...

I am receiving the same error still: Sequential_File_27: Error when checking operator: Unable to initialize the exporter. Sequential_File_27: Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is...

I have all output columns as char and loading into a Fixed width sequential file:Delimeter none:padddedchar as space. still i am getting an error :Sequential_File_27: Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first...

Thanks Ray,

Can you please provide few of the Parallel configuration file setting examples, That will help better for a Reference.

There is no entry in the PDf that tells u about the transform functions like date DateFromDaysSince().Please let me know if you have a header file for that?

ray.wurlod wrote:C:\Program Files\Ascential\DataStage\Docs\parjdev.pdf

Hi There is a Project in Datastage 7.5.2, where all Jobs/batches are Presently of Server Jobs. Now we want to add some new Parallel Jobs/sequencers into the same Project. Need some advice, whether the both Server Jobs and parallel Jobs will run in the same Project and the Parallel Processing feature...

Unfortunately there are no functions defined in transform.h...Please let me know if you can find the correct header with all transform function.

balajisr wrote:Saraswati,

There is a header file named transform.h under /../PXEngine/include/apt_components/stats/.

Is this what you are looking for?

[quote="ArndW"]Hello Saraswati and welcome to DSXchange. I am also on the same search method . I found out /apt_components/general has all the headers for the individual stages.But there is no header for the transform stage.A header of the transform stage may be a clue to the problem..... ...