DSXchange

n.parameswara.reddy@accen

i have datastage on 9.10.226.11 server , but i need to run the unix scripts from this " d06fprdb05.portsmouth.uk.ibm.com " sever through datastage sequence. my problem is how to connect and run the commands from other server through datastage command activity please help us Advance thanks ...

n.parameswara.reddy@accen

CREATE SEQUENCE STEVE.SEQ_KEY_ACCTS AS INTEGER START WITH 1 INCREMENT BY 1; CREATE TABLE STEVE.TESTSEQ LIKE NEG085_20090210.ACCOUNT; INSERT INTO STEVE.TESTSEQ SELECT * FROM NEG085_20090210.ACCOUNT ORDER BY SRC_SYS_ACCT_KEY FETCH FIRST 10 ROWS ONLY; ALTER table STEVE.TESTSEQ ADD COLUMN NEW_SRC_SYS_AC...

n.parameswara.reddy@accen

Step by step. What is your source and what stage are you using to read it? Don't use "view data" to determine whether or not data is being correctly transferred. ... my source is Sequential file and the target is DB2. loaded the chines data into DB2 database with utf8(NLS). it was loaded ...

n.parameswara.reddy@accen

I designed and tested the job for 500 rows of Chinese data. The job successfully executing but the fields having the Chinese data arae loaded as ??? or blank data in file. When iam using NLS Map as gb18030,GB_2312-80 no data is loading. When UTF-8 is taken as NLS Map data is loading in to normal fie...

n.parameswara.reddy@accen

Hi friends.

I Need to install NLS for Chinese characters (1 Chinese character is equal to 2 bytes).

please give me the better solution for the issue

Advance Thanks for your help.

param

n.parameswara.reddy@accen

harikumar wrote:what is use of surrogate key?when we u r using this?

Interview question???

n.parameswara.reddy@accen

nikhilanshuman wrote:try searching for "The configuration does not contain".

RESOLUTION FOR THIS ISSUE IS
we need to assign server name for this parameter in the ADMINISTRATOR
APT_PM_CONDUCTOR_HOSTNMAE = [server name]
there are many posts on this error...

n.parameswara.reddy@accen

i have written one config file for the datastage, but while checking, i am getting below error. Fatal Error: The configuration does not contain the invoking node pvzdv302. configfile { node "node1" { fastname "pvzdv3020" pools "" resource disk "/data001_dwhsPROD/da...

n.parameswara.reddy@accen

I am also facing the same issue, please help me regarding this issue. Ci_Fic,0: U_ILLEGAL_ARGUMENT_ERROR encountered. Change your timestamp to a char(19) and see if the error goes away. I would think it is the nonstandard "MMM" portion that you haven't catered for. ... Hi ArndW Actually th...

n.parameswara.reddy@accen

while running datastage jobs with one user i am getting below issue Tr_Separateur: Failed to load the library "V0S24_JxTHEXT_Gateway_Extract_Log_Tr_Separateur.so"; either the directory containing the library file is not on the library search path, or the library was compiled on a system th...

n.parameswara.reddy@accen

3714 STARTED Tue Jan 5 19:05:44 2010 Starting Job JxRIRCP_controle_presence_fichier_Q075_F. (...) 3715 INFO Tue Jan 5 19:05:45 2010 Attached Message Handlers: (...) 3716 INFO Tue Jan 5 19:05:47 2010 Environment variable settings: (...) 3717 INFO Tue Jan 5 19:05:47 2010 Parallel job initiated 3718 IN...

n.parameswara.reddy@accen

It might be best to store this last-run-date in your database as opposed to a sequential file, that depends on whether or not other processes need to know the last run date. ... Thank ArndW. Even i felt the same for it would be better if the Last Run date was stored in a table.The Problem is the La...

n.parameswara.reddy@accen

Below is the scenario which i want to achieve by means of the Sequencer. Sequencer calls the job that basically extracts the data from the table from certain period of time. For example, when the job is run for the first time given a parameter of start date (eg., 2005/01/01) till current date.(ie.,2...

n.parameswara.reddy@accen

SwathiVineela wrote:Could any one please take this case ASAP?

In the parallel job, inside the format tab ,field delimiter = TAB
and quotes = double options available.

Same option is there in the server job also. check the format option once

n.parameswara.reddy@accen

If the problem is in your
code, you will hit SIGSEGV even if you increase
'maxssiz'. In general, SIGSEGV can happen because
of 2 conditions, 1) illegal address being referenced
and 2) invalid permission for the address.

DSXchange

Search found 40 matches

Connect two UNIX Systems

Logic for DB2 sequence develop in Data stage

Re: Need to install NLS for Chinese characters

Need to install NLS for Chinese characters

Re: hi

Fatal Error: The configuration does not contain the invoking

U_ILLEGAL_ARGUMENT_ERROR

Mmap failed for the librar

Unable to contact one or more Section Leaders

Sequencer Parameter Looping

Re: SIGSEGV when running C++ Routine