DSXchange

Divine, my only two suggestions are to: (a) Use the Key Management functions - this is what they have been designed for or (b) Use the Database's in-built sequence generation facilities. Using a random number to populate surrogate keys is not a good idea. The quickest method in terms of performance ...

Divine,

you can always use the RND(x) function - this returns a pseudo-random number between 0 and (x-1). You can ensure you get either the same or different number sequences by also using the RANDOMIZE() function.

Hello i.peppermint, You can do this type of function from a DataStage Sequence. The basic construct for you would be the loop. You can execute a Unix shell command to get the list of files you need and loop through this list, calling your sub-job(s) and passing the filename in as a parameter to each...

Jayantthakore, You really will need to tell us more - just by stating that player <n> is sporadically being terminated is not going to help anyone localize the issue. Have you looked at any of the log files or error messages? What does the job do? How many nodes do you have configured? It might not ...

banatcp, I cut and pasted your code into a function and, lo and behold, the value of U is, as expected, ABCD. I don't know where your problem is coming from, but your code as posted will produce the expected results. What does X= '"Hello World"' PRINT X[1,LEN(X)-1] print out on your machine?

Hello ghutchin, the high-values coming in are not actually being converted to "?", they are just not displayable. Although the high-value should be the same (i.e. value 255 per byte) you should do a quick test in your job, add a column to the output and use a derivation such as SEQ(In.HighValueColum...

Ian, in your case your are still getting valid 1-byte character codes and don't have to worry about multibyte at all. In addition, you are not doing any mapping from one set to another so you do not need the additional overhead of NLS for your ETL process. Before you go into NLS you need to know wha...

No problem, these two are exceptions, normally your functions & routines are catalogued as DSU.{routinename} and the DEFFUN syntax is the same; but that didn't work when I tried it for your question so I had to look a bit deeper.

Raftsman, you also should add the following code to your BASIC program: $IFNDEF JOBCONTROL.H $INCLUDE DSINCLUDE JOBCONTROL.H $ENDIF This will include the standard DataStage function and routine calls. The two you are referring to are not included in this. You would need to add DEFFUN ConvertWeek(...

Another way for you to do this, especially if you have a specific table where you wish to write the data, is to write a DataStage job which, as either a Job Control basic code or a DataStage function call, use the various DSGet....() function calls to get the information you are looking for and then...

snassimr,

the parsing mechansim in DS will attempt to use the # character as a delimiter, so you would have to quote it. How you go about it depends upon which stage you are using - which is it?

federico.l, there is a DataStage configuration file ($dshome/uvconfig) setting T30FILE which control this value, it would seem that you have exceeded it at runtime. You will need to edit this text file, increase the value to a more acceptable one, stop DataStage, regenerate the configuration file, t...

e_Cartoon, a quick look at your export header shows that this is an export from a Version 5 (or mayhaps 6) DataStage project. DSX files are upwardly compatible, so that should not cause an issue. The 2nd line of the header specifies the CharacterSet, so just replace that value with "CP1252" as Ray s...

Does your workstation eat up 100% CPU while you are waiting? I have a curious (rather sporadic) problem on my system that when I have a job with about 10-20 objects on the designer canvas and leave an "open" link (i.e. delete an output file stage and the link is red and not deleted) it starts using ...

Wiant - I've got AIX 7.5.1.1 here and don't have it either, not that this will help you in any way.