DSXchange

Is there any way of obtaining a list of DataStage installations (version, type and OS wouldn't matter) in the midwest and northeast regions?

Thanks

Hi Kjaouhari, Can you please share the steps you executed to setup the ODBC for DB2. I get SMEC error when I try to bind DB2 ODBC database. ./bind19 XXXXXX(ODBC) User Name: abcdef Password: xxxxxx Package creation failed!: SECMEC value not supported, check for missing user/password. Hi Folks ! I hav...

Hi Kjaouhari, Can you please share the steps you executed to setup the ODBC for DB2. I get SMEC error when I try to bind DB2 ODBC database. ./bind19 XXXXXX(ODBC) User Name: abcdef Password: xxxxxx Package creation failed!: SECMEC value not supported, check for missing user/password. Package creation...

Renita,

Were you able to resolve this issue? I am getting the same error.

Thanks,

Renita wrote:Hi,
The import is still failing using DSN ODBC!
When i bind the DSN i get error
Package creation failed!: Specified security mechanism, (Unknown), is not supported by server.

Any help on this!

garthmac , Were you able to resolve this issue? If so, can you please share the entries in the uvodbc.config and .odbc.ini files. We are currently on DB2 8.1 and DS 7.1(server edition). Thanks. Thanks for your replies, I'm sure you can use the hostname or the IP address, I've testesd this and I get ...

Chulett,


In my case the delimiters in the string are ";" and the @FM characters are "?". Ereplace function only parses the first occurence of "?" I am trying to parse each of the ";" in the entire string.

chulett wrote:The 'derivation' in the Pivot stage just becomes a comma delimited list of the column names to pivot, as noted in the documentation. ...

Can you please share an example to achieving parsing out a single field to multiple rows if I set a max number?

Thanks

Pivot pivots, you need to parse. If you know the max # of fields, parse out that single field to the max, pivot and then filter out any nulls. No counting required. ... Thanks Chulett. So it can be done using pivot if I set the threshold(max to a number. Say, 20). For my eralier sample data set, ho...

I have a situation where a field in the data row in the source is a string delimited by a ','. eg: COL1 COL2 1 1, 2, 3, 4, 5 2 A, B, C, D 3 g, h, i Here is what I am trying to achieve: count the number of occurences ',' and create an individual row. eg: COL1 COL2 1 1 1 2 1 3 1 4 1 5 2 A 2 B 2 C 2 D ...

Randy, Were you able to resolve this issue? if yes, would you mind sharing the steps involved resolving it. I appreciate your help with this! I have added required entries to .odbc.ini and uvodbc.config files. I ran the bind once but it failed because one of the ODBC ports values in the in .odbc.ini...

Amey,

The script works. The only issue with this is, my client may not allow shell script work.

Thanks for your help with this.

Ideally, I'd like this done by calling DSGetLinkInfo function from a transformer stage.

Thanks Amey. I'll give it a shot.

Ray,

I use the actual job name.

Any further suggestions are appreciated!

What is the value of Arg1? Don't assume, check - maybe using DSLogInfo(). If the job name is not spelled and cased correctly, DSAttachJob() will fail to attach the job. ... "Job Name" is the Arg1 value that I pass to DSAttachJob. Cross checked the spelling and no issues there either. Any ...

What is the value of Arg1? Don't assume, check - maybe using DSLogInfo(). If the job name is not spelled and cased correctly, DSAttachJob() will fail to attach the job. ... "Job Name" is the Arg1 value that I pass to DSAttachJob. Cross checked the spelling and no issues there either. Any ...

I use DSJ.ERRNONE but that choice doesn't affect the attachment, only subsequent use of the handle. Have you tried actually using the handle in subsequent steps? From the docs: JobHandle is the name of a variable to hold the return value which is subsequently used by any other function or routine w...