DSXchange

Hi, I want to add a sequence to records in a flat file with surrogate key generator. My job design is simple: sequential file --> surrogate key generator --> sequential file My input file is: aaa bbb ccc ddd eee and what I want to get as the output is: 1 aaa 2 bbb 3 ccc 4 ddd 5 eee With surrogate ke...

Posted: Tue Dec 15, 2009 10:23 pm I'm guessing that the master record is the level 01 item. Hi ray, Thanks for your reply. I have checked the CFF stage "Layout" tab with COBOL format, I found that for every record definition (master record toggled or not), its level 01 item is always the ...

Hi, Can anybody give me an explanation to the "master record" in CFF? In Parallel Job Developer Guide, it says that you can toggle a master record when you define multiple record types but doesn't mention the usage of master record. I wonder what is the master record supposed to do? What c...

Hi Ernie, Thanks for your reply. But I think the restructure stages will make things much more complicate. What I need is to load the table definition dynamically in runtime. Maybe via a schema file or other else. I think it is hardly possible considering the number of table definitions to load for ...

Hi all, I want to design a job to read the EBCDIC file with records of multiple structures and save records with the same structure in one sequential file. I prepare to use CFF as input, and several sequential files as output. I have copybooks and table definitions in datastage for all the structure...

Hi, We'v just installed DataStage client 8.1 on a machine running 8.0.1 client. It did install the Multi-Client and we are able to switch between v8.1 and v8.01. We didn't meet an pb during the install of this DS Client. I mean we just run a default installation. Hope this could help. Rgds Fredj The...

I am loading data from a SQL Server database into Oracle through a parallel job. I have an ODS enterprise stage pointing to SQL Server, Transformer Stage, and finally a Oracle Enterprise stage with following settings: Write Method: Load Write Mode: append My issue comes with the fact that in my data...

I am loading data from a SQL Server database into Oracle through a parallel job. I have an ODS enterprise stage pointing to SQL Server, Transformer Stage, and finally a Oracle Enterprise stage with following settings: Write Method: Load Write Mode: append My issue comes with the fact that in my data...

The workaround is to restart the service :

IBM WebSphere Application Server V6 - repmprdNode01

after the creation of a new job.

Then, the problem doesn't occur.

ray.wurlod wrote:Can you create the Category ODBC\ATRIUM in the Table Definitions branch then attempt the import? ...

No I can't. I got the following err :

"Unable to create new folder." "The Folder 'Jobs' is locked by user 'xmeta' (SessionID 'xmeta-1')

ray.wurlod wrote:Can you create the Category ODBC\ATRIUM in the Table Definitions branch then attempt the import? ...

No I can't. I got the following err :

"Unable to create new folder." "The Folder 'Jobs' is locked by user 'xmeta' (SessionID 'xmeta-1')

Check that you have write permission to all objects in the DataStage project directory, and are credentialled to update the common IIS Repository. ... Thanks for your help Ray. It sems that the permissions are the sames on both project directories. The thing is that I used the sames User Account to...

Hello and welcome to DSXchange, NSIT-DVP-01 a) "pb" is the accepted symbol for the element "lead" but not a word in English. b) What version are you exporting from? c) What error(s) do you get when importing into version 8? d) Can you import single element types (tables, routine...

Hi, I just installed IIS 8.1.0. The problem I have is that I cannot import medatada in a -new project-. I mean that I can import metadata (File structure, Jobs from .dsx file ...) in the project I created during the installation, but I cannot do the same with a new project. Thanks for any info or cl...