DSXchange

Hi Kim,

There can be many instances uvsh.exe (on windows) be seen in task manager, are all these separate processes or these are child processes of a master process? and when we say process ID of a job, which instance of uvsh.exe we are talking about?

Thanks in advance.

When you import through import wizard, click Filter,

It will give you the choice to filter the tables for import by their names or owner names (and some other options for synonyms and sys tables).

" Its is not returning Null, it is just telling you the contents of the record keyed by 449100 and since you don't have anything in the record it is telling you nothing. To understand it, use a Hased file which is having columns other than the key column and you will understand what is it doin...

Its is not returning Null, it is just telling you the contents of the record keyed by 449100 and since you don't have anything in the record it is telling you nothing. To understand it, use a Hased file which is having columns other than the key column and you will understand what is it doing? :wink...

Thank you very much Chulett.

Moreover, I have tried the same thing on more than two machines (two different Oracle databases).

That message has nothing whatsoever to do with the fact that you're casting a CLOB as a VarChar. Read the error message again. The Oracle server is busy at the time. Something preceding hasn't finished when the next call is made through the OCI. Have your Oracle DBA help you to trace what requests ...

$IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF print "hdsjk" OpenSeq "c:\filename.txt" To FileVar Else Call DSLogWarn("This Program","Message") AbcLen=0 Addit=0 FileLine1='' Loop ReadSeq FileLine From FileVar ELSE Ans='1' if FileLine1=FileLine Th...

Hi All, I am facing some problem with Oracle's CLOB datatype. For a COLB datatype column in the Oracle when I specify Varchar(2000) in server job it gives me error ORA-24909: call in progress. Current operation cancelled The description of the Error (from a site) ORA-24909: call in progress. Current...

Try compiling/running the same job with administrator.

The Shared Containers are the reuseable components (that you create, pretty similar to a server job). You have it common across the project. From the Help Shared containers comprise groups of stages and links and are stored in the Repository like DataStage jobs. When you insert a shared container in...

The target table is also showing 'abc'. You need to truncate the data explicitly, for example Code: Left(InLink.Col1,2) I suspect what you're seeing results from C string handling; in C a string is an array of characters, and all array indexes are zero based. So you're seeing Col1[0], Col1[1] and Co...

Hi All, I have a server job which is transferring data from source to target. My Source and Target table are like this Src_Table Col1 Char(10) Tgt_Table Col1 Char(10) In my source stage I am specifying column defintion as Col1 Char(2) And in target Col1 Char(10) In between the Source and target stag...

Use CLEAR.FILE filename

The Command is
CLEARFILE filename
the complete syntax is
CLEARFILE [file.variable] [ON ERROR statements] [LOCKED statements]