DSXchange

Hi All, In my routine (Basic) I am writing a sql script. I am unable to get Single Quote Routine Syntax SqlScript = "SET HEADING OFF\n" SqlScript = SqlScript:"Delete from ":TABLENAME:" Where ETL_KEY in\n" SqlScript = SqlScript:"(Select ETL_KEY from OLB_ETL_LOAD_FAC...

Hi There, 1. It is Basic Routine. 2. It was not compiling and was treating my Routine as Variable and was saying Variable not declared. I have get the things running, I needed to run this in job stage and wanted to avoid Sequencer. What I wanted: was to run a sql script to delete the records>>>Datas...

Hi All, There comes a scenario where I have a Parallel Routine (Transform Function) which Backs out the data in case of fatal error. It is sql script deleting the rows before loading fresh data. I need to run it from with in my pre-existing job(s). How can I get it working?? What I tried so far: I t...

Good Thought.
I am infact 'Truncating the tables'.
However, these effects are committed before I restart my ETL job.
Can 'COMMIT' command be insufficient to release the locks on those tables ???

Thanks and regards,
Munish

Hi All, I am facing another proble with 'NoWait Specified' error. orclServiceDetailFact: Oracle call failed; sqlcode = -54; message: ORA-00054: resource busy and acquire with NOWAIT specified. No one is working with the database however if I restart the server, it works fine for one or two runs befo...

Hi All, Our ETL is going through testing, I am starting getting weird problem, please see the log: SQL*Loader-951: Error calling once/load initialization ORA-03113: end-of-file on communication channel If I stop and restart the server, it works fine for 1-2 runs and then it starts crashing again. An...

Hi All, For deployment, we are exporting the jobs (with DESIGN) and (with EXECUTABLES). If we import these DSX files through manager, the import is fine ie we get the executables along with Design information. We have unix environment and are using ./dsjob -import TestImport /apps/olbs/CBA_ETL/dsx_d...

Yes, it does work with manager.
Is there any special flag with (DSJob -import) to work with Shared Containers???

Any input would be appreciated...

Thanks and regards,
Munish

We are using 7.5.2 Our plan is create independent DSX for individual job. Thus we are creating DSX for job WITHOUT DEPENDENT SHARED CONTAINERS. And want to create independent DSX for Shared Container. Did you imported Shared Container along with the relevant job or of its own. Thanks and regards, Mu...

Hi Ray, It looks as if DSJob -import works only with compiled jobs. Shared container were left out because they were not compiled //*** Can Shared container be compiled, if yes how?? ///*** We found the similar import problem when 1 job which was (which was not compiled) left outside out of 70 jobs ...

Just to share that it worked fine, I have to make slight modifications to syntax (./ before dsadmin command) (may be Unix specific, not sure though). Location $DSHome/DSEngine/bin Delete Project:./dsadmin -deleteproject ProjectTest Start Project: ./dsadmin -createproject ProjectTest -location /opt/W...

Thanks Guys,
You all are brilliant.
Closing the thread.
Regards,
Munish

Hi There, We are trying to automate the deployment project where the plan is to script everything which could be run from Command Line (UNIX). Can anyone throw some light on 1. Template of script for creating a new project (Right now we are using Administrator). 2. Deleting the pre-existing project ...

Any one know a good way to convert an input field of comma separated decimal (for example 12,345.67) to DataStage decimal field? It seems that the implicit conversion doesn't work. Any formatting option can be used with explicit conversion (such as StringToDecimal function)?

Hi All, My project is in deployment stage (Version 7.5). We have aroung 70 jobs, of those 26 jobs are using 3 shared containers. I have created .DSX files for individual job Executables (With Design Information, Without Refrenced Shared Container ) Separate DSX file for Sequencer Another DSX for ind...