DSXchange

I need to send an array to a web service The WSDL contains one field as: /ns1:saveForm/form/additionalInfo/FormInfo/extPayerID/text() and another as: /ns1:saveForm/form/additionalInfo/FormInfo/intPayerID/text() I know that I will always only have 2 groups of these. 1 set of extPayerId and intPayerId...

That's a start - thank you! The field being passed to the web service is defined as 20 in length -so I still am confused about what it is expecting. I am not sure why it would even want a timestamp like this since the java web service input object defines the field as just a Date in the java code. T...

Can someone please show me an example of what a timestamp using this function would look like? I need to do the same but with a parallel job and I am having a lot of difficulty with this field. Oconv(Date(), "D-YMD[4,2,2]") : 'T' : Oconv(Time(), "MTS") : '.000Z' Thanks so much, N...

have been having issues with a date - I am passing a date to a web service - the WSDL import defined the date field (in DB) as a Timestamp - so I am leaving it this way - For some reason, I am getting error message invalid date/time from web service. Another job (Server job) successfully called the ...

I found this post and it was the solution - thank you! Question - other applications use the same sequence (ie. java applications) - would they have to modify their applications or does anyone know if java could handle this datatype as an Integer without having to modify their code. Thank you. Nicol...

I am having issues with the Surrogate Key Generator - and I see others have had the same problem, but I can't seem to figure it out - it seems this Transformer_81,0: Error Idx = 1; DB2Driver Embedded SQL message: ; sqlcode = -1390; sqlstate = Transformer_81,0: Failed to connect to the database Trans...

Thanks Ray - I looked at the surrogate key generator and it looks like it might work - one question - do I need that particular stage? I also see there is a surrogate key generator tab in the stage properties of the transformer stage - which I am using in my job already - can I create the surrogate ...

I am trying to workaround the fact that I am not able to use a sparse lookup in the job I am developing. Basically I have this query - SELECT (NEXTVAL FOR COM.DLN_SEQ) FROM SYSIBM.SYSDUMMY1 This query only retrieves the NEXT 1 value - but I need to retrieve the next 1000 - does anyone have any idea ...

I have a new idea and wanted to run it by everyone - the query I had only retrieved the nextval which was just the next 1 confirmation number - but I think I found a query that will return the exact number that I need immediately from the query (and if I know the number of records that I have ahead ...

Ok, after this last post - I did a few more searches on this group and I think I still have a problem because I can only use the DB2 UDB API stage (since the DB is on a diff server) - I can't use the enterprise stage which gives me the option to do the sparse lookup. From what I heard, the next rele...

Can I do a sparse lookup with v8.0 and I can only use the DB2 UDB API stage because the database is not located on the same box as DS. We are hoping to upgrade to the new version soon - I thought we needed to upgrade in order to use this functionality - I hope not though. Sounds like a lookup to me....

I have a sequential file as input and in the job I will be converting the sequential file into XML - one of the tags on the xml is CONFIRMATION_NMBR - to populate this number i need to retrieve from a table to get the next val. I have the sql for it and I can call it from DB2 stage - how can I conti...

I think it is at -l?

I believe I am seeing the jobs I scheduled when I type this -

chulett wrote:Can you go down to the O/S and see what a "crontab -l" shows for your user? Assuming this is a recurring schedule, that is... ...

What is the command for jobs just executing once? I will eventually want to schedule daily but for now I was testing with just one run.

chulett wrote:Can you go down to the O/S and see what a "crontab -l" shows for your user? Assuming this is a recurring schedule, that is... ...

I always login with the same userid and I would think that as soon as I schedule it in the director - then it would say 'scheduled' (or whatever it says) - but it still just says 'not scheduled'...waiting to see what my DS admin says about this. Schedules in 'cron' or 'at' are by user, are you sure ...