DSXchange

Hi, We were carrying out penetration tests on our network and as I logged into datastage the IP packet was captured. In this packet was both the username and password in clear text. We are not currently using SSL, as we did a default install of InfoSphere and this is without SSL enabled. I've checke...

You're getting this warning because you don't have the column "PD_GRD_EFF_DT" in your before dataset.

Using the search function, you can find the following thread viewtopic.php?t=129991&view=previous&si ... a91871edaf

I have many lookup links... How can I know which link to select.... It is not in log .... And I am getting Ignoring duplicate warning for 5 times.. You can only select one link when choosing the option "Multiple rows returned from link". If more than one link is producing this warning, yo...

Hi bebel_lvm

I just had exactly the same problem this morning, and found a solution that works.

The reason it is putting the two CD_SUPP keys together is because the other information (NOM_SUPP) contains the same data.

Therefore you need to make NOM_SUPP the key and not CD_SUPP

thanks

Smashing, works a treat, cheers mate.

I am in the same place and will be til end of Jan.

Being as diplomatic as I can, Project is OK, with a few issues still to iron out.

I remember our open "something" and it will be with the other in the next day or two.

Aye up Arnd, Hope you're keeping well. I written this: Handle = DSAttachJob("JxDSSFCRSynTAMNAGRP01", DS.LOGFATAL) Ans = DSGetLinkInfo(Handle, "OCI_T1_OFF_STRUCT_REF", "Ln_In_T1_NDS_OFF_STRUCT_REF", DSJ.LINKROWCOUNT) Dummy = DSDetachJob(Handle) But I get the following er...

Sequencers and Triggers

Hi,

I have a job that is called from a sequencer and reads from a table.

If the read produces no rows, I want to stop the sequencer, if it produces rows I want it to run the next job.

Is there a way to do this with in the sequencer??

Thanks,
John

Hi dsxdev,

I tried this in SQL Plus and it works fine. However, it still does not work in the DataStage job.

Thanks.

Yes, its a working job, until I put the DELETE statement in.

It is parsed correctly, as one of the error messages above mentions the parameter:

OCI_T1_NDS_OFF_LINKS,1: ExecuteImmediate failed for:
'DELETE FROM DBADSSDEV.T1_NDS_OFF_LINKS'

Hi Jay,

Yes, all the parameters are defined. It is a job that was working, until the DBA took away all truncate privileges

Thanks

I'm trying to use the Open Command to perform a delete on an oracle table as truncate privileges have not been given for the DB. But I cannot get it to work. The statement I am entering is: 'DELETE FROM #GDSSSchemaOrcl#.T1_NDS_OFF_LINKS' and these are the errors I'm getting: OCI_T1_NDS_OFF_LINKS,1: ...

Thanks everyone.

Works perfectly.

Days of frustration and pulling my hair out is over

Hi, I have a job that reads data from a DB and creates a <filename>Interim.dat file. An after routine is then called which then reads the Interim.dat file and creates an XML file. The only parameter is the filename. How do I create the file <filename>.xml?? I tried using: OpenSeq InputArg:".xml...