DSXchange

I have discovered the use of lookup filesets, the fact being that the fileset is present across all nodes automatically.

I am trying to port (and modify) a routine to call Oracle, originally created in Unix, to Windows. The routine was more complex in Unix as it did a specific job so the sql was fixed. Trying the same thing in Windows always returns the value 32 (which is wrong) and a system return code of 1. I can't ...

Thanks Ray, An interesting alternative which I began to implement then stopped.I really want to avoid the counting and substring techniques as the structure may well change and would make it difficult to maintain. So it appears then, that the multiplication of lines in CFF is normal. Luckily the CFF...

I have to import a Cobol text file and structure into Datastage. The structure has multiple occurs in, some of which are nested Fields Occurs 30 Occurs 6 Occurs 140 Occurs 5 Fields I am experiencing several issues 1) I had to import the decimals e.g. +00568 as strings as they were blank otherwise. I...

This was resolved in the Build Extraction Object screen. When you click on this, you can then modify the conditions associated to each table.

I am unable to pass my parameters to my ABAP job. The ABAP job has been modified by an ABAP developer as we weren't able to perform the task in Build Query When the job runs in trace mode we get SELECT WHERE "MANDANT" = '220' AND "OBJECTCLAS" = ' ' AND "UDATE" = 0000000...

I have checked with other consultants and they have managed to install it on Win7 Pro as long as its 64 bit.

Also I have tried the install under the isadmin user but I still have no success

I have created isadmin as an administrator and read the quickstart guide. Is there any other document I should read ?

Thanks

I am trying to install Client and Server on one PC for a demonstration but I get the following error Error The specified credentials for InfoSphere Information Server must be valid and must refer to a user with administrative privileges. Resolution proposed Check that the supplied user name and pass...

Of course!!

I forgot that I had set the run of the sub sequence to conditional. I have changed that now and added a force abort on SQL check of the table.

Thanks for your assistance

I have a job which operates thus Sequence Select Group to process Process Subgroup 1 to 10 in order Loop 1 to 10 Call SubSequence1 Call SubSequence2 Call Various Jobs End Loop Finish. This is the Datastage schematic calling various sub jobs I have deselected all the Log Warnings/Log Reports and Auto...

Ray, thanks for that. Thats what I needed.

As for the compiled dsx, I meant a job that has been compiled and exported as a dsx (so will have the Universe Basic in )as opposed to a job that has just been saved with no previous compilation.

It has been requested that we create an excel spreadsheet with all of the job sequences and parallel jobs in order of execution Thus S1 - J1- OCI In - OCI Out S1 - J2- DS In - OCI Out - DS Out S2 - S3 S3 - J3 - FF In - OCI Out etc At present my colleague is doing this by hand and we have tens of job...

And make sure there are no fields in the output of the copy stage. The copy stage must be entirely RCP.

Yes the Access database is on the same server and I can access it as a ODBC DSN using Excel