DSXchange

I want to stop the DS job if it exceeds the time period and i want to implement this from the job control which executes a series of jobs. All the statements in the Job controler are executed one after the other. After executing the DSRun statement and before the DSRun statement returns its status, ...

Hi, Can we set timeout period for a job run? For example if we define a timeout period of 10min and if the job runtime takes more than 10min the job should abort and mail has to be sent abt the status.. Any pointer to accomplish this sort of task??? Job can be either a serverjob or parallel job or s...

Hi,
I have resolved the issue. We need to set EnableNcharSupport=1 in the .odbc.ini file for the ODBC connection String.

Thanks & Regards
Vijay Kumar

Hi Ray, Initially the NLS_LANG variables was not set. Now I have set the NLS_LANG as en_US.utf8 . The following are my locale settings on UNIX box. LANG= LC_CTYPE="C" LC_COLLATE="C" LC_MONETARY="C" LC_NUMERIC="C" LC_TIME="C" LC_MESSAGES="C"...

Hi, We have enabled NLS on our Datastage server. The project level default Mapping is UTF8 and Locale settings are US.ENGLISH. The Oracle DB instance is created with the NLS parameters set to UTF8 both NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET are UTF8. We are loading the UTF8 data to the oracle t...

Hi,

Can we specify or set the number of nodes that a QS Job has to execute in Parallel mode.
In Data Stage we have the configuration file. In the same way can we specify the configuration file in Quality Stage in Parallel mode execution.

Regards
Vijay Kumar

Hi Ray, When we search the Controls folder for COUNTRY Files, I got only the following files: -rw-r----- 1 dsadm dstage 22376 May 21 05:50 COUNTRY.CLS -rw-r----- 1 dsadm dstage 1073 May 21 05:50 COUNTRY.DCT -rw-r----- 1 dsadm dstage 140318 May 21 05:50 COUNTRY.PAT We have not over ridden any of the ...

Oh...
I am sorry, In UNIX it takes the fixed length format. I don't know about windows. Sorry if I have misleaded.

Regards
Vijay Kumar

Hi Saad Mirza, The following are some of my inputs for your questions. 1. Which file extension to use for input and output?csv,txt,xls?? The file name should be of maximum 8 characters and you can give just file name with out any extension 2. I have placed it in Data folder..do i need to place it so...

Hi ray, The following is the log file. STN(25826):Fri May 20 18:43:20 2005 LOG: $Build: (SINGLE)RELEASE superstan_7_0_1_7_040120_15:27:07 $ STN(25826):Fr., 20. Mai 2005, 18:43:20 LOG: Start STN(25826):Fr., 20. Mai 2005, 18:43:20 LOG: LOCALE is: de_DE.iso88591 de_DE.iso88591 de_DE.iso88591 de_DE.iso8...

Hi adamski, Could you check whether you have given the standardization rules directory when you deploy the standardization job. you need to give the controls directory location on your machine ex: QS/bin/Apps/MNV/Controls Try this, Hope this could resolve the issue that you are facing, If not, try t...

Hi, I have a standardization job in which I am standarding the Name. When I run the job with 2000 records it is running fine and when I increse the number of records > 2000 I am facing the following run time error: Error exec: /appl/dsadm/Projects/CASHDB/QS/Logs/STNDNAME.Step002.log:STN(19903):Fr., ...

Hi, When I try to deploy the QS job I am getting the following error: Error convert: /appl/qsadm/Ascential/QualityStage/bin/generate_ipicfg.sh -a /appl/qsadm/CASHDB/QS/Scripts/ARDS/STNDNAME -p /appl/qsadm/CASHDB -d /appl/qsadm/CASHDB/DIC -o /appl/qsadm/CASHDB/IPICFG/STNDNAME.cfg -endfile /appl/qsadm...

Hi Arnd,
I just want to see the field names in each pass throgh unix prompt. I don;t want to build he job. I mean I want to see the fields used in each pass from any of the files from Contrlos or Scripts directory for that job.

Thanks & Regards
Vijay Kumar

Hi, Can we find out which fields are used in the matching job from the deployed script. For example : if we lost the front end UI job but the job is already deployed on the unix server. using the deployed job I want to find out which fields are used in each pass of the matching job. I think it is ve...