DSXchange

Hi Chulet,
please find below error.

Exception thrown from CC_OraLoad::prepareDirectPathLoad, file CC_OraLoad.cpp, line 1264: The OCI function OCIDirPathPrepare returned status -1. Error code: 1,821, Error message: ORA-01821: date format not recognized.


Thanks

Sorry small correction in my question. if my oracle target table date field datatype DATE then job getting failed if i choose bulk load and if i set to default option create table then for date fields datatype creating timestamp(9).in this case job not failed.is it necessary to change datatype date ...

Hi, i am using bulk load @oracle_connector stage and job loading data from seq file to oracle table.my input sample date field data is like this 2015-03-31 00:00:00 .After load data date field is showing like 31.03.15 00:00:00.000. Please help on this how to get same input format after load if i use...

Hi, below is my sample query. where column2 have null data in both tables. if execute in db no records. SELECT * FROM table1 a,table2 b WHERE a.column1=b.columns1 and a.column2=b.column2 same scenario in datastage job its passing records to output. by using seq file and hashed file. its ignoring col...

hi, data loaded to from oracle db to seq file and hahsfiles and key columns are column1 and column2. but column2have null data.in the next job joined based on key columns both seq file and hash file but condition not failed even though null values in column2.could you please clarify seq file and has...

Hi,
tried to delete job but unable to delete.while deleting job below error showing.
error:
Cannot get exclusive access to log for job


Thanks a lot..


regards
.....

Hi, when overwriting job in data stage job with updated dsx below error occured.please help on this. error: Runtime item ignored as corresponding design item was not imported. import doing with DSXImportService.sh. below command using for import : /opt/IBM/InformationServer/ASBNode/bin/DSXImportServ...

Hi, example: project A &B contains these 4 jobs and in first 3 jobs using product table in source queries. jobnames : 1.extprd01 2.xfmprd02 3.lodprd03 4.extcust01 my new job(String_search_job) created with localuv(universestage) to find job lists in both projects. When I ran String_search_job in...

Hi, in the job at uniVerse stage using below query.while running job giving parameter value to search string. for example in project A i am searching list of jobs which contains PRODUCT table. similar to in in project B. My job working and giving correct output in PROJECT A but not getting correct o...

Hi, in one server created two datastage projects and in both designed job with localuv(universe stage) to know job lists.but this job working in one project and another project it not working properly. i cross checked uvodbc.config in both project directories. it same only.please help on this why it...

Hi, Please find the below my job problem description. created new server job in project1 and ran successfully.same job exported with executables and imported in project2 and it showed status as compiled. if i run that job failing with below error. info:job1..Delete: %s fatal:job1..Delete: |0| after ...

Hi, please find the jobdetails below. 1. serverA&serverB datastage8.5 serverjobs installed. 2.in server A designed one job. job description: Storedprocedurestage-->seqfile in stored procedurestage specified procedure type as 'transform' and at procedure call syntax placed below sample query BEGI...

In dev and prod servers DS8.5 installed server edition. designed one job and developed and tested in dev server with stored procedure stage and migrated to production server. When its triggered in production server failed with error Error: info:CCVGsmContBase2..DELETE: %s fatal:CCVGsmContBase2..DELE...

Hi, my job is like this. stored procedure stage--> transform--> seqential file i called below statement in stored procedure stage begin delete from sap_sales_base where type=2 ; commit; end; in dev my server job executed successfully. i migrated to prod and ran but showing error. Error: info:CCVGsmC...

Hi,
In server jobs i need to caculate number of months between two dates.i couldnt see any function for that in server jobs.please help on this.

Thanks