DSXchange

Hi Rakesh,

I found a solution to your query:
SRC--> Transformer --> TGT

In Transformer :
Stage Variables ->
svar1 : If IsNotNull(DSLink2.COL) then svar1:',':DSLink2.COL else svar1
svar2 : LastRow()

Constraint : svar2
output column = svar1

Output : 1,2,3,4,5,6,7,8,9,10

chullet: 'There's no such thing as Varchar(11,2). Strings don't have a scale.' Here i meant to say that the metadata defined in the seq file is like : Columnname SQLtype Length Scale col1 varchar 11 2 I guess i should have explained it like this instead of Varchar(11,2) Can I use trim function in se...

ulab,
I guess what u are saying is the basic thing that we have to do before loading the data. But the thing is the amount column length varies. So length is mentioned as Varchar(11,2) which i have already mentioned.

Hi All, My job design is ORACLE ENTERPRISE------->TRANSFORMER--------->SEQ FILE Sequential file has 6 columns. Represented all columns as Varchar(11,2) First two columns are string values,while rest 4 columns contain amount value. When i load the data in seq file, i need data in format for last 4 co...

Hi, as per what i understand here is, ur not able to able to view the pallette right ? I had also faced the same issue. In the customization , as u have shown below , double click on "Load Project Default". The pallette will be restored and u can view the pallette contents. I hope this is ...

Hi All, Im trying to execute a unix script through 'execute command' stage . No other stages used. The value given in the command tab is : sh /rdw/prd/CIS/SCRIPTS/DDD.sh In the parameter section value is : #ScriptDateValue#(which is JUL-2011,partitionvalue of the table). The script is suppose to ins...

asorrell wrote:Can anyone else at your site use the Oracle Enterprise Stage? Just trying to narrow down if this is systemic or just a local issue.

Yes there is another system that is working fine...we have 2 systems with such issue. Its was working fine untill last week on all systems

Hi all I am not able to open Oracle Enterprise stage in from Designer. When I try to open it the desinger is hanging and in turn i have to open the new session of designer and my previous job goes to locked state. I reinstalled the client also. but no use. Can someone guide me on this.. [* Note - I'...

The datastage job was triggered. The job ran for almost 4 hours. Then the job aborted with the warning "Job control process(pid 422276) has failed".
Can anybody help me what is the error exactly?

Why and What do you want to achieve ? We are trying to do the auditing of the jobs basically.The file which is to be read contains all the jobs source name, target name, and their respective input and output link name. Through a dummy job I need to call a before Job routine which would read this fi...

I need to read a file through a routine. Can anyone help me out with this?

Thanks In Advance

... or just use the parameters in the routine call. However, I'm assuming it's not as simple as that and the file names are hardcoded, yes? ... That's true. The source file name are hard coded. We thought of parameterizing but that will not be a better approach. Is there any other way we can get th...

I am creating a routine in server jobs which does the auditing of a particular job. It lists the start time, end time, row count etc. Now the problem is I need to get the source file name and target file name that I am passing in the respective source and target stages. I am able to get the stage na...

I need to create a routine which would run a job by passing the job name parameter in it. Can anybody help me to write the code?
It would be a great help.

Thanks in advance.

Yes, but I certainly wouldn't advise it. Far better to use a job for that and have the routine land the data in a flat file for it to load. ... Could you tell me what would be the issue if we insert data through routine. Can you also tell me with a small example how we write the command in routine?