DSXchange

Hi

can any one help to fix above issue..I already searched for this in datastage and could not find any thing

thks

Hi I am using ODBC to acess SQL server data ..when i read float data type datastage is giving fatal error.. schema reoncillation detected a size mismatch for column ,,whe reading database column DFloat to SFloat column, trancation or loss of pressiion .. I tried to use convert function in SQL to con...

Hi
I want to call unixshell script from job control and store the output value .
please share your thought,
thks

Hi
The above problem was solved when change alternate local in
Quality profile definition from "en_US" to "C".
but i dont understand what is "C" and is it going to effect data .
please share your thought
Thks

Hi
We are upgrading from QS 7 TO QS 7.5.the job run fine in QS 7.0 .
but we got segmentation error when we run in QS 7.5.
i am wondering whether we have to setup 7.5 differently than 7.0.
Pl share your ideas.
THKS

HI
I have a match job which does Undup match option.but job is failing in sort.I dont understnd the log file .can you please share your thought.
Thks

=========== VALSORT ============

Segmentation Fault - core dumped
ERROR: VALSORT FAILED (139)

Hi
We just upgraded to QS 7.5.but it is not handling french data properly.
what changes i have to do in order to fix this bug.pl share ur thought.
thks

Hi
I have some of the following made custom rules
ICMF,DBCITY ETC in my jobs.there rules are not in the list of rules provided by QS.we are upgrading from 7 to 7.5 .what are there rules.
where can i find it.
please do share your thought.
thks

Hi
We want to upgrade Quality Stage 7.0 to 7.5.
we made some custom made rules changes to 7.0 rules and we want to move changes to new 7.5 rules.Is there any software which compares 2 files and put new 7.5 rules to your custom made 7.0 rules.
pl share your thought
thks

Hi
I want to upgrade quality stage from 7 to 7.5.
I am running the jobs seperatly on 7 and 7.5 and compare the output files.
but how can i compare the 2 output files.
please do share your thoughts
thks

Hi I have a job design Seqfile----xfm---------db2 I have 2 sepetate jobs .One for insert into DB2 table and another for delete into DB2 table. I want to delete or insert DB2 table based on Key feild in Seqfile. I want to know whether i have to use target table as lookup and match on key feild and do...

Hi I am using around 10 stage variables each have different if conditions and i concatinate all stage variables and insert into a column. like var1:var2------var10 into Name varchar2(288) field. My problem is when i concatinate all variables i am getting null but if i test individually each result o...

Hi
I am using oci stage at input and LAST_UPDATED(Timestamp) as one of the column.
I want to capture only records whose LAST_ UPDATED > MAX(LAST_UPDATED)

I am tring to use ICONV AND OCONV functions . but i want to know if there is any other approach.
thks

hi
thanks for your reply .DataStage server is in UNIX .
thks
sai

Hi
No i am just cut and past entire thing in the EXECSH line. with file name and file location as parameters.let me know how to solve this problem.
thks