DSXchange

'SIGSEGV' is the signal thrown when an application makes an invalid memory reference or improper memory handling.

I am not sure why and when this signal comes in your case...

just4u_sharath,

test1_dummy_txt,0: Missing record delimiter "\n", saw EOF instead

Clearly, it says about the record delimiter settings.
Check the 'Format' properties of your target sequential file. You might not have specified it.

Try out by using Record delimiter: UNIX newline

Can you try this and check if you could UNLOCK your job: 1. Login to the server with your UNIX id and get into bourne shell , here in example, dev.it.server.com 2. Change you current working directory to DataStage engine directory. here in example, $ pwd /server/etl/ascential/Ascential/DataStage/DSE...

Posted: Wed Sep 28, 2005 11:49 pm

I have posted this couple of years back!!
This was already discussed.

Biuser,
Answers are answered now!!

Can you please put your requirement graphically?

pradkumar,

By looking into your first post, it seems that when you searched the DShelp, you might have found the those functions on the parallel pages but not on the server.
Thats why when you open a transformer they are all missing.

nkln@you,

In these kind of situation the easiest way i used is just a Search in the .dsx file.
Still if you don't want to go by each job dsx file, then export all the jobs and upload it to work work directory of unix and Done!

Why should we?

Ya. If we are going to use message handlers to suppress these kind of warnings, then its OK. Raamc, You have 2 options. 1. If you want a double datatype to be converted to decimal with a warning free job, keep the output datatype of the aggregator as double(default) and when you pass it to the later...

sud, For the option 'Aggregation Type=count' in the aggregator stage the default datatype will be dfloat. If you explicity change it to decimal, you will be getting a warning something like: Implicit conversion from source type "dfloat" to result type "decimal[38,0]": Possible ra...

ArndW,

Seems, even if this parameter is NLS=0 or not present in the list, i guess NLS is not installed...

Thanks ArndW,

I learnt new thing from your post.
There is no tunnable parameter setting for NLS. There is no output line for NLS with the command. So, is it that the NLS is not installed?

Thankyou very much.

Aschand, Below are the default option for most of the databases. When you try to 'LOAD' into database an exclusive lock will be made on the tables to maintain the data integrity. INSERT, UPDATE or DELETE's - will place a ROW EXCLUSIVE lock. SELECT...FROM...FOR UPDATE - will place a ROW EXCLUSIVE loc...

Hi ArndW,

I don't have administrator roles to login into it and see the options. I just have developer Privileges on the project. I don't see any of those NLS tabs on it when connected to it.

Thanks for your time!!

Hi, We had the copy of Datastage installed few months back on the Unix server.I could not see the NLS settings either on the Datastage administrator or the NLS_LANG environment variable. I could not find anything related to this in the DSxchage forums. :( In the dsenv file i found the below settings...