DSXchange

Thanks Ray. It would be great if you could tell how to bind them, I am quite new to using Routines for Database operations. Thanks.

Thanks Ray. I am using the statement as 'INSERT INTO XXXXX(col1,col2) values (:param1,:parm2);' DSExceute command returns 0, but teh following error is logged Message to be logged is... > SP2-0552: Bind variable "parm2" not declared. Parameter names are correct. What could be causing the i...

Hello all, I am facing issue with Insert statement within a Server routine. Cmd1 = 'sqlplus -s ':parmDBName:'/':parmDBPass:'@':parmDBUser:' << EOF' Cmd2='set heading off' If parmActionCd='I' Then Cmd3 ='INSERT INTO XXXXX(col-name1,col-name2) values(parm1,parm2);' Cmd4 = 'EOF' Cmd = Cmd1:Char(10):Cmd...

Hello,

I am planning to start preparation for Infosphere DataStage 8.0.1 certification.
Can you suggest some documentation apart from documentation which comes with DS client intallation.

Appreciate your help.

Hello, I am writing records from a sequential file after certain transformations to Oracle table in a 8.1 server job. The DB stage used is DRS stage. The update action is "Clear table then insert rows". Delete operation does not seem to be happening eventhough there is a DELETE FROM <db us...

Hi, I am using 8.1 and I am writing to write a message to a remote queue using the MQ Connector stage. I am unable to see the properties for the connector stage when I wanted some configuration changes. When I faced the issue before, I uninstalled 8.1 client and then reinstalled it and it started sh...

Hi, I am trying to do an ssh to the UNIX box where DataStage is mounted and trying to run a job using dsjob -run command ssh remote server /tech/ascential/Ascential/DataStage/DSEngine/bin/dsjob -run project jobname [code] I got the error message as ld.so.1: dsjob: fatal: libvmdsapi.so: open failed: ...

Hi I have set Array Size as 1000 in the Oracle OCI stage. When run, job aborted with error ORA-01002: fetch out of sequence. When I selected the 'Disable Array Fetch' checkbox , my job finished successfully. Some times job finishes successfully even when the Disable Array Fetch is not selected. What...

Hi, I've to implement a leap year check for a data field. I use the MONTH.LAST transform function in a routine. When I compile the routine, I get the compilation error as Array 'MONTH.LAST' never dimensioned. 1 Errors detected, No Object Code Produced. What is the cause? I did a search in the forum,...

Craig,

My search for 'Fetch out of sequence' didn't return any results.

What could be the cause? Appreciate your help.

Thanks.

All, I'm reading records from Oracle table using OCI stage and write to a sequential file. The query performs UNION all operation on two tables which have history records and these tables have huge number of records. When I run the job, the job gets aborted with error Ora - Fetch out of sequence I'm...

Hi All,

I faced a weird situation in Data Stage. I had a job which was tested.
The next day when I opened the job, what I could see is that all mappings in the transformer vanished. What could be the issue? The job was fine the previous day. I would appreciate if any one could throw some light.

Hi, I want to check whether input date field is of expected format for date fields in different files. If I pass the expected length and date format to a routine, will the below example work If Len(Arg1)=8 And Not(IsNull(Iconv(Arg2,'DMDY[2,2,4]'))) Then Ans=1 End Else Ans=0 I've to write the record ...

As mentioned in the previous post I call the routine with the filed name,field value,maxlength,null flag('Y' or 'N' as the value),numeric flag('Y' or 'N' as the value),date flag ('Y' or 'N' as the value). Source is a flat file.First stage variable calls the routine with the first field name which ne...

Hi, I'm using a routine to do field validations. Multiple fields in a record should be validated for null,maxlength,numeric format,date format. If any of the fileds fail the validation, that record need to be sent to error table and there is no validation required for any other fields for that recor...