DSXchange

Hi,

i am getting error when i try to load the hash file which is Type 30.

Error Message:

DataStage Job 115 Phantom 16604
Unable to allocate Type 30 descriptor, table is full.

Please help me on this.

Hi all, I'm not able to delete the projects thru Administrator Client. Its saying 1) "Error Calling Subroutine: *Datastage*DSR.ADMIN(Action=9); Check DataStage is set up correctly in project UV (The connection is broken(81002)) Then if i click the OK button, its giving the below message serious...

Failed to connect to DataStage server: XXX, project: XXXX (Internal Error (39202))

Hi, I have created a user thru web console from user menu and assigned his role to suite user and Datastage and Quality Stage user. And also I have created the same user at OS level. And I logged into Datastage Administrator and assigned to a project with the role as operator, but i'm not able to lo...

Hi,

I am getting numeric values in a column. It contains both kind of numeric values i.e. 123 and 123.45

Now I need to check whether the incoming value is whole value(123) or floating value(123.45).

Could anyone help me how to check the value?

Thanks in Advance

Hi Ray,

we are using oracle oci stage for source and target.

Hi Chulett,

The below line is the one i found in the file

Pin%%V11S3P4.Column%%12 = (' ')

Thanks in Advance.

Hi all, My few datastage jobs getting aborted due to the "Abnormal termination of stage J_NPL_Negotiation_Rates..Trans_CR_NCR_NPL detected" . My Job design is below. Src Oracle -------> Transformer --------> Tgt Oracle ^ | Lkp Oracle Oracle version : 10.2.0.2.0 I had reset the job and foun...

Hi all, When I try to export a job or project, I'm getting the error message as below. unexpected error;quitting Then once I click the Ok button, I'm getting the below message. MyCreateObject: Internal error - Could not create object with OLEType=VMDatastage.CDSRProgress After clicking OK button, I...

Hi all, When I try to export a job or project, I'm getting the error message as below. unexpected error;quitting Then once I click the Ok button, I'm getting the below message. MyCreateObject: Internal error - Could not create object with OLEType=VMDatastage.CDSRProgress After clicking OK button, I'...

Hi all, I have created a server routine, saved, compiled and tested. The problem is, when i try to use the routine in server job transformer from DSRoutine, the created routine is not visible. I have refresed the repository and also I have tried by closing the session and re-opened the session. Coul...

You need to load this into what datatype in Oracle? There's no "time" type, so what... DATE? TIMESTAMP? VARCHAR2? Only the latter will take a "time" value with no correspoding date associated with it. Chulett, I changed the column to varchar in oracle table and now it is working...

Hi, From sequential file, i'm getting time value as 00:00:00 and need to load to oracle database. But I'm not able to load the value, its giving the below error message. J_Time_Convert..Tran_Detail_Records: At row 1, link "Lnk_2", while processing column "MAKERTIME" Value treated...

Hi, I am using the below command to execute the job from command line but its throwing the error message. /data/IBM/InformationServer/Server/DSEngine/bin/sh dsjob -run isadmin FINETL J_Stg_BBS_Account -param TPFileName=eBBS_FINETL_ACCOUNT_BH -param COUNTRYCODE=BHR -param Source_System=BBS Error: ./d...

Disk full? File permissions? Directory permissions? Verify parameter value (posted in "job starting" event in job log). Ray, The directory and file has full rights. Disk is not full. #$SrcPath##TPFileName#_CTL.txt $SrcPath --> /data/FINETL/incoming/ TPFileName --> BH_RAMS_TRAILBAL When I ...