DSXchange

Hi Guys, Please help me Datastage gurus: I created job like this ODBC -----------> Trabsformer ------------> Hash file (Output stage) I made it as Shared container I used this shared container in my main job as a reference (reference link). but i created it as a stream link...... so i am getting err...

Thanks alot sir.

Hello sir, My situation is like this sir. I created a simple job just loading product table into a hash file for weekly load jobs. Job : ODBC stage + Transformer stage = hash file. I highlighted ODBC stage + Transformer stage and created shared container. After that i used this shared container in m...

Thanks for quick response. But i have to create shared container as per my specifications. I created a job with final output as a hash file,so for reusuability i need to create that job as a shared container for that i copied this job and pasted into a served shared container palatte. when i am tryi...

Hello Sir, I created a job to create a hash file after that i want to make it as a shared container because i am going to use it in 20 more jobs,so i went for server shared container there i copied this job and highlited other than output link and clicked shared container.but when i am going to use ...

Hi Guys,

I created a simple load job and made it as shared container,when i am trying to use that shared container in another job as a input what i observed is i couldn't see "MAP TO CONTAINER LINK",
Please advice me what i did wrong.

Thanks for help.

Thanks
Narasa

Hi Guys, Good morning. I have a question on environment variables. I have created datasource as string in client admin and used as #$datasource# in odbc stage everything works fine but i created passwd as encrypted and i try to use in odbc stage as #$passwd# i am getting problem. please advice me ho...

Hello Sirs, I have master customer file and 4 ODBC Dataware house tables like cust_address,country,region,geography tables. I have to Insert all records into cust_address table where no customer key and customer addrtype = 's' not found in cust_address table when matched with master customer file us...

The access violation implies permission issue with the stage. You need to provide more info on what you are doing and what error message and at what stage. Sainath, I used Complex flat file for that ebcidic file while i tried to view the file I am getting Error calling subroutine: DSD.Browse (Actio...

Hello Sirs,


I got some EBCDIC files so i used complex flat files and did some process,

But my job aborted with this error:

Exception raised in GCI subroutine: Access violation.

Datastage phantom aborting with @ABORT.CODE=3.

Can i set up any properties.

Thanks
Narasa

Hello Sirs, In my German input file i have some german characters ,so i did is i used NLS ISO 8859-1 for the input file i did some process i write into a filex with project default NLS upto this point everything... But when i write into ODBC Stage (Database) the job was aborted... please help me on ...

As noted - yes. But you don't go from Prod to VC back to Dev. Everything is in VC, so you simply take the most recent version of the job (i.e. the one currently in production) or any previous version (technically) and promote it from VC back to development. Also as noted, make sure you clear the 'R...

Hello Sirs,

Can we demote jobs from production to version to dev.
i know it's a silly question but i have to give explanation to my client.

Thanks
Narasa

Hello Sir, Last week i did experiment on version control on windows server,it looks like fine.......but i have a question on initialization and promotion. for doing initialization we have plans to give authorization to developers also but for promote to production it's for 2 people in a team... my q...

If something external to DataStage is locking the table there is nothing DataStage can do except wait for that lock to be released. All YOU can do is scheduled the DataStage job to run at a time (and lock the table) when the mainframe is not locking the table. This isn't a DataStage problem. You wo...